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