Rename duplicate keys in objects by adding an incremental integer postfix

Question

How can I map an array of objects with the same keys to subsequent keys with an incrementing integer as its postfix?

Input:

[
    {
        "test1": {},
        "test1": {}
    },
    {
        "test2": {},
        "test2": {}
    }
]

The above input receiving and expected output would be as below like each object set supposed to contain different combination of keys like (test1 and test2)

Expected Output:

[
    {
        "test1": {},
        "test2": {}
    },
    {
        "test1": {},
        "test2": {}
    }
]

What should be the output of `[{"test1":"a","test1":"b"},{"test3":"c","test3":"d"},{"test4":"e","test4":"f"}]` ? — Harshank Bansal, Jul 04 '22 at 08:37
Can the object also contain non duplicate keys as well? like `[{"test1":"a","test1":"b", "test0": "c"},{"test3":"c","test3":"d"}]` — Harshank Bansal, Jul 04 '22 at 13:55

aled · Answer 1 · 2022-07-03T21:00:09.283

If we assume that all the elements have the same keys in the same order we can get all the keys then map each object in the array. Each element of the array is an object, we can use mapObject() to replace the keys by the list of keys.

%dw 2.0
output application/json
fun getKeys(a:Array)=a reduce ((item,acc=[])->acc << namesOf(item)[0])
var allKeys=getKeys(payload)
---
payload map ($ mapObject ((value, key, index) -> (allKeys[index]):value))

Output:

[
  {
    "test1": {
      
    },
    "test2": {
      
    }
  },
  {
    "test1": {
      
    },
    "test2": {
      
    }
  }
]

Rename duplicate keys in objects by adding an incremental integer postfix

1 Answers1