Spotfire.Dxp.Data.Transformations Namespace TIBCO Spotfire 7.12 API Reference
The Spotfire.Dxp.Data.Transformations namespace contains classes for transforming imported data.
Classes
  Class Description
Public class AddCalculatedColumnTransformation
Represents a DataTransformation that uses an ExpressionTransformation to create a new calculated column.
Public class ChangeDataTypeTransformation
Represents a DataTransformation that uses an ExpressionTransformation to change the DataType of one or more columns.
Public class ChangeNameTransformation
Represents a DataTransformation that uses an ExpressionTransformation to change the name of one or more columns.
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 ExcludeColumnsTransformation
Represents a DataTransformation that uses an ExpressionTransformation to exclude a set of columns.
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, 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 class ExpressionTransformationWrapper
A wrapper for a number of simple DataTransformations. The wrapper uses ExpressionTransformation internally. Examples include AddCalculatedColumnTransformation and ChangeDataTypeTransformation.
Public class NormalizationTransformation
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 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 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 class ReplaceColumnTransformation
Represents a DataTransformation that uses an ExpressionTransformation to replace an existing column with a calculated column.
Public class ReplaceSpecificValueTransformation
Represents a DataTransformation that replaces values on specific rows, or on a single specific row.
Public class ReplaceValuesBaseTransformation
Represents a base class for the replace value transformations.
Public class ReplaceValuesTransformation
Represents a DataTransformation that replaces all values in a column that match a given value.
Public class SortRule
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 class UnpivotTransformation
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.