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 field or fields on which you want to apply a function in the list. Tip noteIf you want to apply the same function to multiple fields at once, click the
 Open dialog icon to open a tree view that allows you to select multiple fields. |
| Attribute field name |
Give a name to the field that will represent the field names in the input. |
| Value field 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 Value field name.
