How to convert comma separated values to rows in SnapLogic?

[Surendar]

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 jkl
2 mno
2 pqr

Need to convert columns to rows in Snaplogic. Kindly let me know for any suggestions? thanks in advance!!

[nganapathiraju]

From a high level,

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

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

[Surendar]

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

[nganapathiraju]

Did you use the group by N before this?

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

[Surendar]

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