Merging Fields using transformation in Celigo

Fields may be merged , creating a list of values from the arrays in the record. In the example below, the items 1,2,3 and the prices 10, 20, 30 have been transformed into a merged record of items and their relative prices

Pre-TransformTransform MappingsPost-Transform
{         
“itemsNames”: [“item1”,     “item2”, “item3”],         “prices”: [10, 20, 30]
}
This image has an empty alt attribute; its file name is kbtrans-2.png{        
“items”: [            
{               
“name”: “item1”,                    “price”: 10              
},              
{                 
“name”: “item2”,                     
“price”: 20              
},            
{                 
“name”:”item3″,                 “price”: 30             }    ]  }

Leave a comment

Your email address will not be published. Required fields are marked *