The PivotTransformation type exposes the following members.
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 a 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 a 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.
|
See Also