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

[AvaniAnand]

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 for credit and one for debit based on the two elements in the array?

[JensDeveloper]

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