cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert comma separated values to rows in SnapLogic?

Surendar
Contributor

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 jkl
2 mno
2 pqr

Need to convert columns to rows in Snaplogic. Kindly let me know for any suggestions? thanks in advance!!

7 REPLIES 7

please use group by N and try

I used “group by N”. after shift validation the error got resolved but unable to get proper result set.

please refer my below screenshot for reference.

image

image

mswain
Employee
Employee

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.