Unpivot processor
Unpivots table columns to rows.
For data stored in tables, the Unpivot processor allows you to rearrange the table so that some or all columns are stored as rows instead, highlighting data differently according to your needs. Users familiar with Qlik script may know this operation as crosstable.
Usage
The Unpivot processor requires one input flow and can generate only one output flow.
Properties
Properties to configure to unpivot your columns.
| Property | Configuration |
|---|---|
| Unpivot fields |
Select the check box in front of each column you want to unpivot as row. You can also use the Select all check box to select all columns at once. It is particularly useful if you have a large number of columns to edit. |
| Attribute field name |
Give a name to the field that will represent the field names in the input. |
| Attribute value name | Name of the field with the values. |
To rename the processor or edit its description, click the 
Edit icon next to the processor name in the Properties panel.
Example
The following example describes the effect of the unpivot function on a table containing a target number for sales, by region and sales person. In this case, each target sales number needs to be displayed on a single row. To obtain this output, configure the processor to unpivot the Lisa, James and Sharon fields, enter sales person as name for the Attribute field name, and target as Attribute value name.
