References → Unpivot Recipe

Unpivot is a tool that can transpose rows from an input dataset into columns. The output of an unpivot tool will be the number of fixed columns with the addition of two more columns - one with the remaining column names and the other with column values. This can be especially useful when working with data where columns are date-based and require aggregation.

Configuration

ConfigurationDescription
Recipe NameA freeform name of how a user would like to name a recipe
InputSelect a previously constructed recipe to process
Fixed Column(s)Select the column that should not be affected by the unpivot
Column Headers Unpivoted NameSelect the name for the column containing all the column header values
Column Values Unpivoted NameSelect the name for the column containing all the column data values
Note

Please note that all unpivoted columns must share the same data type category (e.g. all strings, or all numeric). If errors occur during the unpivot, use a select column tool to remove columns with the inconsistent data type.

Sample

Input Data:

YearJanFebMarch
2024565167315453
2023146338927747
2022123212212232

Configuration:

  • Fixed column: Year

  • Column Headers Unpivoted Name: Month

  • Column Headers Unpivoted Name: Value

Output Data:

YearNameValue
2024Jan5651
2024Feb6731
2024March5453
2023Jan1463
2023Feb3892
2023March7747
2022Jan1232
2022Feb1221
2022March2232