Forum Discussion

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

Former Employee

8 years ago

From a high level,

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

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

Surendar
Contributor
8 years ago
I have applied the same logic but getting error like below group itself undefined.
- nganapathiraju
  Former Employee
  8 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
    8 years ago
    I used “group by N”. but not Group by Fields Even after null safe also facing the same.🙄