Combine fields from multiple JSON Objects from an Array based on a matching key

Question

I have below input

{
  "error1": [
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634518"
    },
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634519"
    },
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634520"
    },
    {
      "store": "1202",
      "DocumentNumber": "FF15974433790786634520"
    }
  ],
  "error2": [
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634518"
    }],
  error3:[]
}

i want to export following result

{
    "error1": [{
            "store": "1201",
            "DocumentNumber": ["FF15974433790786634518", "FF15974433790786634519", "FF15974433790786634520"]
        },
        {
            "store": "1202",
            "DocumentNumber": ["FF15974433790786634520"]
        }
    ],
    "error2": [{
        "store": "1201",
        "DocumentNumber": ["FF15974433790786634518"]
    }]
}

i got result with following script. may i know do we have alternate simple method. bcs i felt my code is too complicated fun mapper(payloadItem:Array) = (payloadItem groupBy $.storeCode) pluck(value,key) -> {"storeCode": (key), "salesOrderNumber" : value.salesDocumentNumber} --- (error filterObject ((value)->sizeOf(value)!=0)) mapObject { ($$): mapper($) } — maomifadacai
– maomifadacai, Commented Dec 31, 2020 at 8:39

Abhay · Accepted Answer · 2021-01-03 11:40:21Z

2

Try the below script

%dw 2.0
output application/json
---
(payload filterObject ($ != [])) mapObject ((value, key, index) -> {
    (key): (value groupBy $.store) pluck ((iValue, iKey) -> {
        store: (iKey),
        DocumentNumber: iValue.DocumentNumber
    })
})

answered Jan 3, 2021 at 11:40

Abhay

3241 gold badge3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Salim Khan · Accepted Answer · 2020-12-31 10:21:36Z

2

Try with this:

Input:

{
  "error1": [
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634518"
    },
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634519"
    },
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634520"
    },
    {
      "store": "1202",
      "DocumentNumber": "FF15974433790786634520"
    }
  ],
  "error2": [
    {
      "store": "1201",
      "DocumentNumber": "FF15974433790786634518"
    }],
  "error3":[]
}

Script:

%dw 2.0
output application/json
--- 
payload filterObject ($ !=[]) mapObject {
     ($$) : $ groupBy $.store mapObject {
            temp:{
                store: $.store[0],
                DocumentNumber: $.DocumentNumber
            
}} pluck($)
}

Output:

{
  "error1": [
    {
      "store": "1201",
      "DocumentNumber": [
        "FF15974433790786634518",
        "FF15974433790786634519",
        "FF15974433790786634520"
      ]
    },
    {
      "store": "1202",
      "DocumentNumber": [
        "FF15974433790786634520"
      ]
    }
  ],
  "error2": [
    {
      "store": "1201",
      "DocumentNumber": [
        "FF15974433790786634518"
      ]
    }
  ]
}

edited Dec 31, 2020 at 10:21

answered Dec 31, 2020 at 9:17

Salim Khan

4,31313 silver badges15 bronze badges

4 Comments

maomifadacai Over a year ago

thanks. i don't know how to iterate in dataweave, so i had to use "fun mapper(payloadItem:Array) = (payloadItem groupBy $.storeCode) pluck(value,key) -> {"storeCode": (key), "salesOrderNumber" : value.salesDocumentNumber} " to get item

maomifadacai Over a year ago

one more question, can i use "DocumentNumber: $.DocumentNumber" instead of DocumentNumber: $.*DocumentNumber. seems there have same output.

Salim Khan Over a year ago

thanks for pointing that out.. It probably spilled over from a different approach that i was working on for this solution. I will edit the answer with the update.

Salim Khan Over a year ago

As well just a suggestion, please do put code snippets in an answer block vs comments as they can be structure to be more readable in the former style as compared to a bit clumsy in the latter.. Thanks

Collectives™ on Stack Overflow

Combine fields from multiple JSON Objects from an Array based on a matching key

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related