mule - 在 Mulesoft Dataweave 2.0 中展开数组

Question

我有一个扁平的客户数组，但找不到合适的方法(方式)来展开它，以便每个客户和他的年龄都嵌套。

输入

{
 "1st Customer": "2216",
 "Age": "90",
 "2nd Customer": "2231",
 "Age": "90",
 "3rd Customer": "2249",
 "Age": "120",
 "4th Customer": "2302",
 "Age": "150",
 "5th Customer": "",
 "Age": ""
}

输出

{
 "customers": [
  {
   "CustomerSeq": "1",
   "CustomerID": "2216",
   "Age": 90,
  },
  {
   "CustomerSeq": "2",
   "CustomerID": "2231",
   "Age": 90,
  },
  {
   "CustomerSeq": "3",
   "CustomerID": "2249",
   "Age": 120,
  },
  {
   "CustomerSeq": "5",
   "CustomerID": "2302",
   "Age": 150,
  }
 ]
}

Answer 1

非常感谢，亚历克斯
除法正是我要找的

解决方案[包括去除空值]:

%dw 2.0
output application/json

import * from dw::core::Objects
---
customers:
  ((payload filterObject ((value, key, index) -> value != "")) divideBy 2) map (
    (pCustomer, indexOfpCustomer) -> {
      CustomerSeq:indexOfpCustomer+1,
      CustomerID: pCustomer[0],
      Age: pCustomer[1]
    })