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.DataDataTransformation
Spotfire.Dxp.Data.TransformationsPivotTransformation
Namespace: Spotfire.Dxp.Data.Transformations
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 25.11.10401.3615 (25.11.10401.3615)
Syntax
C#
[SerializableAttribute] [PersistenceVersionAttribute(6, 0)] public sealed class PivotTransformation : DataTransformation
The PivotTransformation type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | PivotTransformation |
Public constructor.
|
Methods
| Name | Description | |
|---|---|---|
| Connect | Connect to the input reader, a DataRowReader
can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.) |
 | ConnectCore | Connect to the input reader, a DataRowReader
can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GenerateDataHistoryCore |
Create detail information for the DataTransformation.
See DataHistoryBuilder for more information on
how to add detailed information to the data history.
(Inherited from DataTransformation.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
Properties
| Name | Description | |
|---|---|---|
 | CategoryColumns |
Category columns values are used for grouping data into result columns.
There will be an aggregated result data column for each distinct combined value of the Category columns.
|
| CategorySeparator |
The category separator to be used when combining category values for value column names.
|
| IdentityColumns |
Identity columns are passed through and identify each row of the result data.
|
| LoadReport | Gets the PartialDataLoadReport that can be used to
report errors during connection.
(Inherited from DataTransformation.) |
| Name | Gets the display name of the transformation.
(Inherited from DataTransformation.) |
| ResultNamingExpression |
Naming expression for the aggregated result data columns.
This naming expression is a string containing placeholder to be
replaced with values during Pivot as follows: %M is replaced with the aggregation method name (empty string for None). %V is replaced with the value column name. %C is replaced with a concatenated list of category values separated by Category separator. |
| SortRules |
Rules for how result columns should be sorted. See SortRule.
|
| TransferColumns |
TransferColumns are aggregated over the identity columns and stored into result transfer columns.
See ColumnAggregation.
|
| TransferNamingExpression |
Naming expression for the aggregated transfer result columns.
This naming expression is a string containing placeholder to be
replaced with values during Pivot as follows: %A is replaced with the aggregation method name (empty string for None). %T is replaced with the transfer value column name. |
| TypeId | Gets the type identifier for the data source.
(Inherited from DataTransformation.) |
| ValueColumns |
Each value column data is aggregated over identity columns and category columns
and stored into the result data columns.
See ColumnAggregation.
|
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