Transpose array row to columns

Hi @Precy,

Instead using the pivot snap, you can try with the “toObject” function.

I am attaching simple pipeline, please take a look/validate and see the output preview.

SL_Community_2020_08_31.slp (4.7 KB)

If this not works for you, please provide the desired output that you want to achieve.

Regards,
Spiro Taleski

Thanks @Spiro_Taleski,

That worked like a piece of cake.
Now i want to place the input present in Value array to the transposed column respectively.

I tried $ASSETATTRID.toObject(x => x, x =>( $VALUE.toObject(x => x))), but not working as expected. When we have any input like [null,‘test’,null,…]

Let me give you in detail my requirement. Below is the input

where input present in ASSETATTRID array to be transposed as columns which is working, and input present in VALUE array to be distributed as a value to respective transposed columns.

I need the output as follow: