PivotTransformation Properties

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.

The category separator to be used when combining category values for value column names.

Identity columns are passed through and identify each row of the result data.

Gets the PartialDataLoadReport that can be used to report errors during connection.

Gets the display name of the transformation.

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.

Rules for how result columns should be sorted. See SortRule.

TransferColumns are aggregated over the identity columns and stored into result transfer columns. See ColumnAggregation.

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.

Gets the type identifier for the data source.

Each value column data is aggregated over identity columns and category columns and stored into the result data columns. See ColumnAggregation.