PivotTransformation Members TIBCO Spotfire 6.0 API Reference
The PivotTransformation type exposes the following members.
Constructors

  NameDescription
Public methodPivotTransformation
Public constructor.
Back to Top
Methods

  NameDescription
Public methodConnect
Connect to the input reader, a DataRowReader can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.)
Protected methodConnectCore
Connect to the input reader, a DataRowReader can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Protected methodGenerateDataHistoryCore
Create detail information for the DataTransformation. See DataHistoryBuilder for more information on how to add detailed information to the data history.
(Inherited from DataTransformation.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Back to Top
Properties

  NameDescription
Public propertyCategoryColumns
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.
Public propertyCategorySeparator
The category separator to be used when combining category values for value column names.
Public propertyIdentityColumns
Identity columns are passed through and identify each row of the result data.
Public propertyLoadReport
Gets the PartialDataLoadReport that can be used to report errors during connection.
(Inherited from DataTransformation.)
Public propertyName
Gets the display name of the transformation.
(Inherited from DataTransformation.)
Public propertyResultNamingExpression
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.
Public propertySortRules
Rules for how result columns should be sorted. See SortRule.
Public propertyTransferColumns
TransferColumns are aggregated over the identity columns and stored into result transfer columns. See ColumnAggregation.
Public propertyTransferNamingExpression
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.
Public propertyTypeId
Gets the type identifier for the data source.
(Inherited from DataTransformation.)
Public propertyValueColumns
Each value column data is aggregated over identity columns and category columns and stored into the result data columns. See ColumnAggregation.
Back to Top
See Also