Spotfire.Dxp.Data.Transformations Namespace

TIBCO Spotfire 10.0 API Reference
The Spotfire.Dxp.Data.Transformations namespace contains classes for transforming imported data.
Classes

  ClassDescription
Public classAddCalculatedColumnTransformation
Represents a DataTransformation that uses an ExpressionTransformation to create a new calculated column.
Public classChangeDataTypeTransformation
Represents a DataTransformation that uses an ExpressionTransformation to change the DataType of one or more columns.
Public classChangeNameTransformation
Represents a DataTransformation that uses an ExpressionTransformation to change the name of one or more columns.
Public classColumnAddition
Represents an added calculated column in the expression transformation.
Public classColumnAdditionCollection
Represents a collection of columns to add.
Public classColumnAggregation
A column aggregation is the combination of a DataColumnSignature representing a column and a string holding an Aggregation Method name.
Public classColumnRemoval
Represents a removal of one or several columns.
Public classColumnRemovalCollection
Represents a collection of columns to remove.
Public classColumnReplacement
Represents a replacement of one or several columns with a column formed from an expression in the expression transformation.
Public classColumnReplacementCollection
Represents a collection of columns to replace.
Public classColumnSelection
Defines a selection of columns.
Public classDataFunctionTransformation
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 classDataTransformationTypeIdentifiers
Defines the identifiers for built-in data transformations.
Public classExcludeColumnsTransformation
Represents a DataTransformation that uses an ExpressionTransformation to exclude a set of columns.
Public classExpressionTransformation
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, also providing an expression, name and, optionally, a formatter. The column selection can be either a fixed set of columns, or a column search expression which will be reevaluated each time the transformation is executed. Use the column name symbol to refer to the columns selected in expressions.
Public classExpressionTransformationWrapper
A wrapper for a number of simple DataTransformations. The wrapper uses ExpressionTransformation internally. Examples include AddCalculatedColumnTransformation and ChangeDataTypeTransformation.
Public classNormalizationTransformation
Represents a DataTransformation that uses an ExpressionTransformation, doing a normalization on one or more columns.

The columns computed by this transformation can either be added as new columns, or they can replace the selected input columns.

Public classPivotTransformation
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 an aggregation method and a value column, denotes a column, in a result matrix of data cells. Each cell is the aggregated result of all data values having the same identity and category. Additional transfer columns may exist, holding values aggregated by identity only, and not by category.
Public classReplaceColumnTransformation
Represents a DataTransformation that uses an ExpressionTransformation to replace an existing column with a calculated column.
Public classReplaceSpecificValueTransformation
Represents a DataTransformation that replaces values on specific rows, or on a single specific row.
Public classReplaceValuesBaseTransformation
Represents a base class for the replace value transformations.
Public classReplaceValuesTransformation
Represents a DataTransformation that replaces all values in a column that match a given value.
Public classSortRule
A sort rule describes the property to sort by, and whether the sort order should be Ascending or Descending.
A list of sort rules is used by the PivotTransformation to rearrange the order of columns.
Public classUnpivotTransformation
Transforms short-wide data into tall-skinny data. Unpivot merges data from multiple value columns into one result column. Data in identity columns is repeated for each value column and the name of the value column is placed into a category column.