Transformation - I need to remove an array inside an object-flatten

Question

In Mulesoft there is a function called "flatten". Is there something similar in SL ?

My problem is described in the pic below. I need to remove bsn array and bring its child objects into the products.

I was able to split the bsn into a new array. Now how do I remove bsn from the original object? and merge them to accomplish my goal as shown in pic 1 ?

koryknick · Answer

aakumar&nbsp;- for simplicity I would solve this with 2 Mapper snaps.&nbsp; The first, configure as follows:

Note the use of Passthrough and the Mapping Root so we can work within the products array.&nbsp; Then we're using the Object.merge() method to pull the elements from the "bsn" array into the "products" array objects.
The second Mapper configured as below simply drops the "bsn" array from the products array.

Hope this helps!
&nbsp;

dbapat · Answer

aakumar&nbsp;You can also use use the AutoPrep Snap to flatten the incoming data hierarchy..&nbsp;https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2568781882/AutoPrep?src=search

aakumar · Answer

dbapat,&nbsp; how about an example?

aakumar · Answer

@&nbsp;Ruth Stento.

Forum Discussion

Transformation - I need to remove an array inside an object-flatten

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found