Ajay_Chawda
5 years agoContributor
Add prefix to each column
Hello Experts,
for eg. if i have 50 columns and wanted to add some prefix to each column value then without mapping individual column in mapper how can i do it?
Regards,
Ajay
Hi @maisie_wang ,
Use a mapper, and map your incoming path up until “@wd:ID”. Than use the following expression:
$…wd:ID.filter(x=>x.get(‘@wd:type’) != ‘WID’)
Regards,
Bojan
The approach will work but it's not ideal. It requires passing previous results as input to a child pipeline in a loop and keeping everything in memory and complicates the implementation. A better solution would be to add an option to send and modify the body content for subsequent calls.
Add prefix to each column | SnapLogic - Integration Nation - 5682