Transposer

Transposer converts columns to rows. Transposing data is the opposite of pivoting data using the Group Statistics stage, which transforms row data into columns.

To understand Transposer, consider the following example. A table contains four quarters of sales data and you want to add all the revenue generated and to analyze the growth achieved in first three quarters. To accomplish this, use Transposer to create a column containing all the revenue of three transposed quarters. Using Transposer to add all the revenues generated in different columns into a column potentially improves performance instead of adding them in different columns.

The following table explains the options in the Transposer dialog box.

Option	Description
Transposed fields header	Type a header name for the column that will contain those columns which are to be transposed. This new column is automatically added to the dataflow.
Transposed values header	Type a header name for the column that will contain the transposed column values. This new column is automatically added to the dataflow.
Retain transposed fields	Check this option to retain all the transposed fields as columns in the output.
Field Name	Displays all the column headers of input file.
Type	Displays the data type of the respective fields (column headers). The columns to be transposed should have compatible data type in the input source file. Below is the compatibility matrix. The tick marked grids correspond to the compatible data types.
Transposed	Check the box next to each field that you want to convert to a column. In order to prevent a column from getting transposed and retain it in the output, clear the check box.