cancel
Showing results for 
Search instead for 
Did you mean: 

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

aakumar
New Contributor III

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 ?

aakumar_0-1704888362513.png

 

aakumar_2-1704888804850.png

aakumar_0-1704889001349.png

 

 

4 REPLIES 4

koryknick
Employee
Employee

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

koryknick_0-1704922440244.png

Note the use of Passthrough and the Mapping Root so we can work within the products array.  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.

koryknick_3-1704922627049.png

Hope this helps!

 

dbapat
Employee
Employee

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

aakumar
New Contributor III

dbapat,  how about an example?

aakumar
New Contributor III