DataWeave-如何在数组中的一个对象中以相同的顺序加入SKU列表

Question

如何在数组中的一个对象中以相同的顺序加入SKU列表。

输入：

[{
 "number": "7358",
 "sku": "301-01",
 "desc": "1"
}, {
 "number": "7358",
 "sku": "301-02",
 "desc": "2"
}, {
 "number": "7359",
 "sku": "301-03",
 "desc": "3"
}, {
 "number": "7359",
 "sku": "301-03",
 "desc": "4"
}, {
 "number": "7360",
 "sku": "301-03",
 "desc": "5"
}]

输出：

[{
  "number": "7358",
  "list": [{
      "sku": "301-01",
      "desc": "1"
  }, {
      "sku": "301-02",
      "desc": "2"
  }]
}, {
  "number": "7359",
  "list": [{
      "sku": "301-03",
      "desc": "3"
  }, {
      "sku": "301-03",
      "desc": "4"
  }]
}, {
  "number": "7360",
  "list": [{
      "sku": "301-03",
      "desc": "5"
  }]
}]

输出我们只创建一个新的“列表”数组，其中包含具有共同顺序的SKU和DESC。任何帮助将不胜感激。谢谢。

Answer 1

嗨，萨利姆（Salim）所示的最好方法是我进行了一些修改，

%dw 2.0
output application/json
---
payload 
    groupBy ((item, index) -> item.number)
    mapObject ((value, key, index) -> 
        {
            number: key,
            list: value map ((item, index) -> item - "number") //We remove the number field
        }
    )

简单的组件是组的关键是组的标准，因此它是数字，最简单的重新构建输出结构的方法是通过执行地图和删除。 “数字”字段

Answer 2

尝试此脚本：

%dw 2.0
output application/json
---
payload groupBy $.number mapObject ((value, key, index) -> {
           number: value.number[0],
           list: value reduce ((item1, a =[]) -> a + { sku: item1.sku ,  desc: item1.desc})
}
)

这是与输出匹配的更新脚本：

%dw 2.0
output application/json
---
payload groupBy $.number pluck $ map ((item,index) -> {
           number: item.number[0],
           list: item reduce ((item1, a =[]) -> a + { sku: item1.sku ,  desc: item1.desc})
}
)

Answer 3

正如其他经验丰富的成员所提到的那样，groupby是实现这一目标的正确方法。但是，我注意到给定方法的输出有差异。以下脚本将输出一系列项目。

脚本将根据评论中提供的新更改而更新以添加运输日期。假设是订单（编号）的运输日期。

%dw 2.0
output application/json
var itemByNumber = payload groupBy ((item) -> item.number)
var removeKeys = ["number", "shippingDate"]
---
keysOf(itemByNumber) map ((key) -> 
do  {
    var item = itemByNumber[key]
    ---
    {
        number: key,
        shippingDate: item[0].shippingDate,
        list: item map ($ -- removeKeys)
    }
})

输出

[
  {
    "number": "7358",
    "shippingDate": "28/04/2022",
    "list": [
      {
        "sku": "301-01",
        "desc": "1"
      },
      {
        "sku": "301-02",
        "desc": "2"
      }
    ]
  },
  {
    "number": "7359",
    "shippingDate": "29/04/2022",
    "list": [
      {
        "sku": "301-03",
        "desc": "3"
      },
      {
        "sku": "301-03",
        "desc": "4"
      }
    ]
  },
  {
    "number": "7360",
    "shippingDate": "27/04/2022",
    "list": [
      {
        "sku": "301-03",
        "desc": "5"
      }
    ]
  }
]

输入

[
  {
    "number": "7358",
    "shippingDate":"28/04/2022",
    "sku": "301-01",
    "desc": "1"
  },
  {
    "number": "7358",
    "shippingDate":"28/04/2022",
    "sku": "301-02",
    "desc": "2"
  },
  {
    "number": "7359",
    "shippingDate":"29/04/2022",
    "sku": "301-03",
    "desc": "3"
  },
  {
    "number": "7359",
    "shippingDate":"29/04/2022",
    "sku": "301-03",
    "desc": "4"
  },
  {
    "number": "7360",
    "shippingDate":"27/04/2022",
    "sku": "301-03",
    "desc": "5"
  }
]