Unpivot

Definition

Returns rotating columns of a table-valued expression into column values.

Parameters

1. Columns (+add):

   • Def: Specify the name of the Column input.

2. Columns names (+add):

   • Def: Specify the name of the columns to unpivot.

3. New column name:

   • Def: Specify the name of the new column.

4. Value column name:

   • Def: Specify the value for the new column.

Additional comments

The unpivot columns have to be in the same format.