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

nganapathiraju
Former Employee

From a high level,

use group by N with 0 documents, combine them into an array (group)

group.toString().split(‘,’)

I have applied the same logic but getting error like below group itself undefined.
image

Did you use the group by N before this?

Also can you try with null safe access and see what you get?

I used “group by N”. but not Group by Fields Even after null safe also facing the same.🙄