Pivots tall-skinny data into short-wide data.
Pivot is based on identity columns and category columns, where each distinct identity denotes a row and each distinct category together with aggregation method and value column denotes a column in a result matrix of data cells. Each cell is the aggregated result of all data values having same identity and category. Additional transfer columns may exist only holding values aggregated over identity, not by category.
Pivot is based on identity columns and category columns, where each distinct identity denotes a row and each distinct category together with aggregation method and value column denotes a column in a result matrix of data cells. Each cell is the aggregated result of all data values having same identity and category. Additional transfer columns may exist only holding values aggregated over identity, not by category.
Inheritance Hierarchy
Spotfire.Dxp.Data DataTransformation
Spotfire.Dxp.Data.Transformations PivotTransformation
Namespace: Spotfire.Dxp.Data.Transformations
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 18.10.8513.5432 (18.10.8513.5432)
Syntax
Remarks
if only identity and transfer columns are specified the result of this Pivot transformation will be an aggregation of the transfercolumns over the identity columns.
Version Information
See Also