aetl:processing_data:working_with_unpivot

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.

1. Multiple columns Pivot

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

The following diagram shows a data pivot with multiple columns:

2. Single column Pivot

For example, a file that holds 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:

Example of Pivoted Data

UnPivoted Data

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

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • aetl/processing_data/working_with_unpivot.txt
  • Last modified: 24/06/2015 17:17
  • by admin