Forum Discussion

Surendar's avatar
Surendar
Contributor
9 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
Surendar's avatar
Surendar
Contributor
9 years ago

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

nganapathiraju's avatar
nganapathiraju
Former Employee
9 years ago

please use group by N and try

  • Surendar's avatar
    Surendar
    Contributor
    9 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.