Forum Discussion

Precy's avatar
Precy
New Contributor
5 years ago

Transpose array row to columns

Hi Team,

I need to convert the values present in an array with comma separated into different columns. Not sure how to use pivot snap for this logic, can someone help me with the same?

4 Replies

  • Precy's avatar
    Precy
    New Contributor

    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,…]

  • Precy's avatar
    Precy
    New Contributor

    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: