Unpivot

Contents[Hide]

The Unpivot transform combines multiple columns into a single column containing new rows (opposite of Pivot).

Transform - Unpivot
Transform - Unpivot

1. Input

The Unpivot transform requires one input transform that has at least three 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 need to configure the following settings:

Unpivot transform configuration dialog
Unpivot transform configuration dialog

Set Unpivot Column Name to name the new column that will contain the names of all of the unpivoted columns (e.g., the days of the week in our example).

Set Value Column Name to name the new column that will contain all of the unpivoted column values.

  • Select the Unpivot columns, which will be combined into a single column.
  • 3. Output

    The figure below illustrates the output from the Unpivot transform in our example.

    Example output
    Example 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