Unpivot

Supported in: Batch, Streaming

Unpivot is the opposite operation of pivot. This converts multiple columns into rows, transforming data from a wide format to a long format. To do so it creates two new columns: one containing the original column names as values, and another containing the corresponding data values. All other columns that are not unpivoted are kept as is.

Transform categories: Aggregate, Popular

Declared arguments

• Columns to unpivot - List of columns to unpivot.
  List<Column<T>>
• Dataset - Dataset to perform unpivot on.
  Table
• Output unpivoted column name - Column name given to the output column that contains the unpivoted columns.
  Literal<String>
• Unpivoted values output column name - Column name given to the output column that contains the unpivoted values.
  Literal<String>

Type variable bounds: T accepts AnyType

Examples

Example 1: Base case

Argument values:

• Columns to unpivot: [new_york_miles, london_miles]
• Dataset: ri.foundry.main.dataset.a
• Output unpivoted column name: city
• Unpivoted values output column name: miles

Input:

Output:

---

Example 2: Base case

Argument values:

• Columns to unpivot: [new_york_miles, london_miles]
• Dataset: ri.foundry.main.dataset.a
• Output unpivoted column name: city
• Unpivoted values output column name: miles

Input:

Output:

---