Forum Discussion

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

Contributor

9 years ago

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

Former Employee

9 years ago

Did you use the group by N before this?

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

Surendar
Contributor
9 years ago
I used “group by N”. but not Group by Fields Even after null safe also facing the same.🙄
- nganapathiraju
  Former Employee
  9 years ago
  please use group by N and try
  - 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.