The PivotTransformation type exposes the following members.
Back to Top
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