Working with UnPivot

The UnPivot data transformation converts columns to rows. It takes an unnormalized dataset and turns it into a normalized version by expanding values from multiple columns in a single record into multiple records with the same values in a single column.

Pivot types

There are two different kinds of Pivot tables:

Multiple columns Pivot

For example, a dataset that lists shops’ sales has one row for each shop, with the month and the sales amount shown in columns in the row.

The following diagram shows a data pivot with multiple columns:

Single column Pivot

For example, a file that holds a list of products bought by the customer with product codes delimited by semicolon.

The following picture shows a data pivot with a single pivot column.

After the Unpivot transformation normalizes the data set, the data set contains a different row for each product that the customer purchased.

The following diagram shows a data after it has been unpivoted:

Pivoted Data Example

UnPivoted Data

Configuring the UnPivot Transformation

To change UnPivot properties double click on the object.

Fill in Description and select appropriate Pivot type

Note:

Following actions apply only to multiple fields Pivot

Create all necessary Groups and Outputs

Once it is done Map Input fields to Outputs and Groups

Result