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

From a high level,

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

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

Surendar's avatar
Surendar
Contributor
8 years ago

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

  • nganapathiraju's avatar
    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's avatar
      Surendar
      Contributor
      8 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
        8 years ago

        please use group by N and try