Unpivot Details

Element Details: Unpivot

Available in: Logi Info

Source code name: Unpivot

The Unpivot element converts one row of data with multiple columns of data values into multiple rows with a single data value.

Columns identified as LabelColumns are repeated for each new data row created from the unpivot operation. To skip a column of data just add the appropriate column name to the RemoveColumns attribute. All other columns will be unpivoted.

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

LabelColumns

UserDefined

A comma delimited list of the datalayer column names that are not pivoted. As columns of data are converted into rows, the values in these columns are repeated for each new row of data. If left blank, then all columns are pivoted into rows.

RemoveColumns

UserDefined

A comma delimited list of columns to remove from the data.

UnpivotColumnID

UserDefined

(Required) The name of the new column to contain the column headings.

UnpivotValueColumnID

UserDefined

(Required) The name of the new column to contain the data values.

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.