dataweave 2-如何通过索引内部对象加入2个数组，而不会丢失数据父对象

Question

如何通过索引加入3个数组（lines，pckslip和linesDT），并通过linesDT生成一个数组对象，之后您必须生成一个新的字段“ totalCost”，该字段是在LinesDT Array中添加所有成本元素的“成本”字段，请注意原始对象中的“数字”字段均保留给父母产生的所有新元素。

输入：

{
  "lines":[
    {
       "requestedQuantity":1,
       "pendingQuantity":0
    },
    {
       "requestedQuantity":2,
       "pendingQuantity":0
    }
 ],
 "number":"98",
 "pckSlip":[
    {
       "trackingNumber":"10534",
       "boxesNum":1
    },
    {
       "trackingNumber":"00049",
       "boxesNum":1
    }
 ],
 "linesDt":[
    {
       "number":"5678",
       "cost":7.7
    },
    {
     "number":"1234",
     "cost":7.3
    }
 ]
}

OUPUT：

[
  {
     "number":"5678",
     "cost":7.7,
     "requestedQuantity":1,
     "pendingQuantity":0,
     "trackingNumber":"10534",
     "boxesNum":1,
     "totalCost":15,
     "order":"98"
  },
  {
     "number":"1234",
     "cost":7.3,
     "requestedQuantity":2,
     "pendingQuantity":0,
     "trackingNumber":"00049",
     "boxesNum":1,
     "totalCost":15,
     "order":"98"   
  }
]

注意：我们生成2个新元素，因为它们是在元素数组中“ LinesDT”中发现的索引的总数。

任何帮助将不胜感激。谢谢。

Answer 1

映射行的每个元素可为您提供在其他数组中使用的索引。 ++运算符可用于将所有对象连接在一起。计算出的字段添加为另一个对象。

%dw 2.0
output application/json
var totalCost = sum(payload.linesDt.*cost)
---
payload.lines map (
    $ 
    ++ payload.pckSlip[$]
    ++ payload.linesDt[$]
    ++ {totalCost: totalCost, order: payload.number}
)

输出：

[
  {
    "requestedQuantity": 1,
    "pendingQuantity": 0,
    "trackingNumber": "10534",
    "boxesNum": 1,
    "number": "5678",
    "cost": 7.7,
    "totalCost": 15.0,
    "order": "98"
  },
  {
    "requestedQuantity": 2,
    "pendingQuantity": 0,
    "trackingNumber": "00049",
    "boxesNum": 1,
    "number": "1234",
    "cost": 7.3,
    "totalCost": 15.0,
    "order": "98"
  }
]

Answer 2

假设每个数组的大小将相同。

脚本

%dw 2.0
output application/json
---
1 to sizeOf(payload.lines) map {
    (payload.linesDt[($)] ++ payload.lines[($)] ++ payload.pckSlip[($)] ++ ("totalCost": sum(payload.linesDt..cost) as String) ++ ("order": payload.number))
}

输出

[
  {
    "number": "5678",
    "cost": 7.7,
    "requestedQuantity": 1,
    "pendingQuantity": 0,
    "trackingNumber": "10534",
    "boxesNum": 1,
    "totalCost": "15",
    "order": "98"
  },
  {
    "number": "1234",
    "cost": 7.3,
    "requestedQuantity": 2,
    "pendingQuantity": 0,
    "trackingNumber": "00049",
    "boxesNum": 1,
    "totalCost": "15",
    "order": "98"
  }
]