PivotTransformation Class

TIBCO Spotfire 6.0 API Reference

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.

Inheritance Hierarchy

System Object
Spotfire.Dxp.Data DataTransformation
Spotfire.Dxp.Data.Transformations PivotTransformation

Namespace: Spotfire.Dxp.Data.Transformations
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 13.19.7018.3940 (13.19.7018.3940)

Syntax

C++

Copy to Clipboard Print

[SerializableAttribute]
[PersistenceVersionAttribute(6, 0)]
public sealed class PivotTransformation : DataTransformation

[SerializableAttribute]
[PersistenceVersionAttribute(6, 0)]
public sealed class PivotTransformation : DataTransformation

Remarks

if only identity columns are specified the result of this Pivot transformation will be a disitinct values of the identity columns.

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.