Unpivot

Contents[Hide]

The Unpivot transform allows combining multiple columns into a single column (opposite of Pivot).

Transform - Unpivot
Transform - Unpivot

1. Input

The Unpivot transform requires 1 input transform that has at least 3 columns.

For example, the input could be a SQL Select transform that corresponds to the following Excel sheet:

Input Data: Excel sheet with 6 columns
Input Data: Excel sheet with 6 columns

2. Configure

In the Unpivot configuration dialog, you must configure the following settings:

Unpivot transform configuration dialog
Unpivot transform configuration dialog

  1. Unpivot Column Name - The new column name in which the column names which are going to be un-pivoted will be placed into as values. (e.g. the DayOfWeek column from the Excel sheet). This column will be part of the output as well.
  2. Value Column Name - The new column name in which the value of the columns to be un-pivoted will be place into. (e.g. the Sales column from the Excel sheet).
  3. Unpivot columns - columns that will be unpivoted.

3. Output

The figure below illustrates the output from the Un-Pivot transform as applied to the Excel sheet.

Unpivot - sample output
Unpivot - sample output

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri