combine values for same key for array of objects

Question

I have the following input data

[
  {
    "key": "a",
    "value": [
      "1"
    ]
  },
  {
    "key": "a",
    "value": [
      "2"
    ]
  },
  {
    "key": "b",
    "value": [
      "3"
    ]
  }
]

and would like to merge the values into an array, grouped by the same key. i.e. the following desired output:

[
  {
    "key": "a",
    "value": [
      "1",
      "2"
    ]
  },
  {
    "key": "b",
    "value": [
      "3"
    ]
  }
]

any help is appreciated thank you!

Jorge Garcia · Accepted Answer · 2021-07-01 23:21:44Z

3

One option can be using groupBy and then accommodating the groups you get like this:

valuesOf(payload groupBy ((item, index) -> item.key)) 
    map ((group, index) -> {
    "key": group[0].key,
    "value": flatten(group.value)
})

This is producing the output you shared.

answered Jul 1, 2021 at 23:21

Jorge Garcia

1,3839 silver badges15 bronze badges

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

Comments

Salim Khan · Accepted Answer · 2021-07-02 02:31:22Z

2

Similar approach. a bit different usage of functions.

%dw 2.0
output application/json
---
payload groupBy ($."key") mapObject {
    "key": $[0].key,
    "value": $ map {
        temp: $.value[0]
    }.temp
}

answered Jul 2, 2021 at 2:31

Salim Khan

4,31313 silver badges15 bronze badges

Collectives™ on Stack Overflow

combine values for same key for array of objects

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related