Spotfire.Dxp.Data.Transformations Namespace TIBCO Spotfire 7.0 API Reference
The Spotfire.Dxp.Data.Transformations namespace contains classes for transforming imported data.
Classes
  Class Description
Public class ColumnAddition
Represents an added calculated column in the expression transformation.
Public class ColumnAdditionCollection
Represents a collection of columns to add.
Public class ColumnAggregation
A column aggregation is the combination of a DataColumnSignature representing a column and a string holding an Aggregation Method name.
Public class ColumnRemoval
Represents a removal of one or several columns
Public class ColumnRemovalCollection
Represents a collection of columns to remove.
Public class ColumnReplacement
Represents a replacement of one or several columns with a column formed from an expression in the expression transformation.
Public class ColumnReplacementCollection
Represents a collection of columns to replace.
Public class ColumnSelection
Defines a selection of columns.
Public class DataFunctionTransformation
Represents a data transformation that uses an external function as a filter. The external function must take a single table as input and produce a single table as output. Metadata is not handled.
Public class DataTransformationTypeIdentifiers
Defines the identifiers for built-in data transformations.
Public class ExpressionTransformation
The expression transformation allows adding, replacing and/or deleting columns. This is generally done by supplying a column selection to work on and in the first two cases an expression, name and optionally formatter to replace it with. The column selection can either be a fixed set of columns or a column search expression that will be reevaluated each time the transformation is executed. To be able to refer to the columns selected in expressions use the column name symbol.
Public class PivotTransformation
Pivots tall-skinny data into short-wide data.
Pivot is based on identity columns and category columns, where each distinct identity denotes a row and each distinct category together with aggregation method and value column denotes a column in a result matrix of data cells. Each cell is the aggregated result of all data values having same identity and category. Additional transfer columns may exist only holding values aggregated over identity, not by category.
Public class SortRule
A sort rule describes the property to sort by and if sort order is to be Ascending or Descending.
A list of sort rules is used by the PivotTransformation to rearrange order of columns.
Public class UnpivotTransformation
Transforms short-wide data into tall-skinny data. Unpivot merge data from multiple value columns into one result column. Data in identity columns are repeated for each value column and the name of the value column is placed into a category columns.