Unpivot Node

Description

Use the Unpivot node to reverse data that is pivoted. Pivoted data is great for presentation, but is not a good format for data analytics. You can use the Unpivot node to combine multiple columns into separate row values.

Options

• Category: the fields that were used in the index and columns
• Value: the value that was aggregated
  

Tips

• You can also select specific columns you would like to keep without unpivotting them.
  

SQL Equivalent

select {pivot_index}

from {data_source}

unpivot (

    SUM({pivot_value}) for [pivot_column]

)

```





[↩️ Back to Workflow Settings](/en-us/category/workflows-kcbeuo/)

Updated on: 05/10/2024