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