Dataweave transformation of converting objects with same key to array of objects

Question

Below example contains same key "row". There may be thousands of such objects. I need an optimal solution in converting below object:

{
    "row":{
        "name": "abc"
    },
    "row":{
        "school": "pqr"
    }
}

Required output:

{
    "rows":
    [
        {
            "name": "abc"
        },
        {
            "school": "pqr"
        }
    ]
}

What is "optimal" for you exactly? You need to define the criteria to evaluate answers and decide which is more optimal. — aled
– aled, Commented Apr 18, 2023 at 11:36
Optimal in the sense, looking for a less expensive solution. Because around 7000 objects will be there and key for all of them as 'row' — Mule-Newbie
– Mule-Newbie, Commented Apr 19, 2023 at 12:32
Again, expensive in what sense? A specific metric? Any of the answers fails to meet a criteria? — aled
– aled, Commented Apr 19, 2023 at 13:13
The answers are perfect and works fine. Thank you for that; Could you point me to the one which will have less impact on memory and will be faster. — Mule-Newbie
– Mule-Newbie, Commented Apr 19, 2023 at 13:58
No. I can make a guess it is the answer using the multi-value selector because it uses only one simple operation, but to actually be sure implies performance testing in real conditions (ie similar payloads and hardware/software to what you expect in production), taking measurements of the metrics that you are interested and analyzing them. — aled
– aled, Commented Apr 19, 2023 at 14:24

aled · Accepted Answer · 2023-04-18 11:35:17Z

5

Just make use of the Multi-value Selector to get all keys with same key name:

https://docs.mulesoft.com/dataweave/2.4/dataweave-selectors

%dw 2.0
output application/json
---
rows: payload.*row

edited Apr 18, 2023 at 11:35

aled

26.5k4 gold badges36 silver badges52 bronze badges

answered Apr 18, 2023 at 11:34

StackOverflowed

7593 silver badges7 bronze badges

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

4 Comments

aled Over a year ago

This is the simplest solution.

Karthik Over a year ago

It works well if all key names are row only @aled .In question its mentioned below example contains "row"

aled Over a year ago

This answer works for the conditions of the question. If keys could be different it should be mentioned in the question.

Mule-Newbie Over a year ago

All objects will have same key for eg. row in this case.

aled · Accepted Answer · 2023-04-18 11:34:13Z

2

Here groupBy will help to group similar keys and pluck will convert object to array.

Solution 1: using mapObject(). This is a better solution since 2 plucks are eliminated here with respect to the second solution below.

%dw 2.0
output application/json
---
(payload groupBy $$) mapObject (($$): ($ pluck $))

Input

{
    "row":{
        "name": "abc"
    },
    "row":{
        "school": "pqr"
    }
}

Output

[
  {
    "row": [
      {
        "name": "abc"
      },
      {
        "school": "pqr"
      }
    ]
  }
]

Solution 2: using map()

If you want rows as hardcoded key then replace (($ pluck $$)[0]):($ pluck $) with ("rows"):($ pluck $)

%dw 2.0
output application/json
---
(payload groupBy $$)pluck $ map{
    (($ pluck $$)[0]):($ pluck $)
}

edited Apr 18, 2023 at 11:34

aled

26.5k4 gold badges36 silver badges52 bronze badges

answered Apr 18, 2023 at 7:31

Karthik

2,4274 gold badges14 silver badges32 bronze badges

Collectives™ on Stack Overflow

Dataweave transformation of converting objects with same key to array of objects

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related