The Unpivot data transformation converts columns into 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.

There are two different kinds of Pivot tables

1.Multiple columns Pivot

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

The following diagram shows a data pivot with multiple columns.

Multiple Fields Pivot Example

2. Single column Pivot

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

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

Single Fields Pivot  Example
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 data after it has been unpivoted.

Result of UnPivot data transformation

 

Configuring the Unpivot Transformation
  • To change UnPivot properties double click on the object.UnPivot  data transformation
  • Fill in Description and select appropriate Pivot typeUnpivot Properties
    Single Fields UnPivot Properties
    Following actions apply only to Multiple fields Pivot
  • Create all necessary Groups and OutputsUnPivot Properties - Pivot Groups
  • Once it is done Map Input fields to Outputs and GroupsUnPivot - Pivot Mapping Properties
Direct link, no registration required.