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 occur

• Pivot column...: the column to be pivoted

• Use values in...: the columns where values are found to fill the pivoted columns

• Aggregate values using...: the aggregation function to be used when aggregation has to be performed

Example

Input

Reshape - pivot input

Configuration

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

Output

Reshape - pivot output