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

Updated on: 05/10/2024