How To Rename Array key or Column

Designing Pipelines
#1

Hi ,

I have an array and I want to change the key/column names of it.
{
“Items”:{
“Item”:[
{
“Item”:’“Pen”,
“Desc”:“Black”
},
{
“Item”:"Pen ",
“Desc”:“Blue”
}
]
}

i want to rename the Item as WM_Item and Desc as WM_Desc

#2

Hi @sjakathi

Please check the attached sample pipeline:

SL_Community_2021_02_02.slp (3.6 KB)

Hope this will help.

Regards,
Spiro Taleski

1 Like
#3

This expression in a Mapper snap:
$Items.Item.map(value => value.mapKeys((value, key) => "WM_" + key))

will add the ‘WM_’ prefix to the keys for each item in this Item list.

Having it mapped to the target Items.Item will replace the old value with your desired output.

1 Like
#4

Thanks you all for the reply it worked…