Forum Discussion

Surendar's avatar
Surendar
Contributor
8 years ago

How to convert comma separated values to rows in SnapLogic?

I have a requirement, based on the column values I need to split the records ID NAME 1 abc,def,ghi 2 jkl,mno,pqr ID NAME 1 abc 1 def 1 ghi 2 jk...
expression_language
transform
mswain's avatar
mswain
Employee
8 years ago

IMO, this can be achieved in 3 steps:
Step 1. Split the Name on basis of comma.
Step 2. Create an array using map() with ID and NAME as key like below:
$array.map(x => {‘ID’: $ID,‘NAME’:x})
Step 3. Use json splitter.