Pivot
The Pivot step
The Pivot step allows to transform rows into columns. It is the reverse operation of an unpivot
step.
Pivoting a column into several columns means that every unique label found in that column becomes a column header. The column gets pivoted “around” fixed columns that you can specify. You also need to specify a value column where values will be found to fill pivoted columns. If aggregation needs to be performed, you can choose the aggregation function (sum
by default).
Step parameters
Keep columns...
: the columns to remain fixed, around which the pivot will occurPivot column...
: the column to be pivotedUse values in...
: the columns where values are found to fill the pivoted columnsAggregate values using...
: the aggregation function to be used when aggregation has to be performed
Example
Input

Configuration
{
"index": ["Label"],
"column_to_pivot": "Country",
"value_column": "Value",
"aggfunction": "sum"
}
Output

Last updated
Was this helpful?