Forum Discussion

AvaniAnand's avatar
AvaniAnand
New Contributor
6 months ago

How to split data in a nested array into multiple rows?

I'm trying to simply split an array of fields within an array into two discreet records        for example in the above illustration, how do I split the array lineList into two records one ...
JensDeveloper's avatar
JensDeveloper
Contributor II
6 months ago
Copy Link

Hi AvaniAnand ,

Do you mean you want to split the nested array based on credit or for debit? Or you always wanne split for debit and credit? 

If you want them both I suggest using a copy and then two json splitters for splitting on Credit and Debit. You can add parent keys that you wanne keep. In the attachment is a demo pipeline that does this (first change the name to '.slp' extension and then import it into snaplogic) it does not allow me to upload those file extensions.

Let me know if this helps.

Regards

 

Jens