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
nganapathiraju's avatar
nganapathiraju
Former Employee
8 years ago

please use group by N and try

Surendar's avatar
Surendar
Contributor
8 years ago

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.