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 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.
|
See Also