Spotfire.Dxp.Data.Transformations Namespace

Represents a DataTransformation that uses an ExpressionTransformation to create a new calculated column.

Represents a DataTransformation that uses an ExpressionTransformation to change the DataType of one or more columns.

Represents a DataTransformation that uses an ExpressionTransformation to change the name of one or more columns.

Represents an added calculated column in the expression transformation.

Represents a collection of columns to add.

A column aggregation is the combination of a DataColumnSignature representing a column and a string holding an Aggregation Method name.

Represents a removal of one or several columns.

Represents a collection of columns to remove.

Represents a replacement of one or several columns with a column formed from an expression in the expression transformation.

Represents a collection of columns to replace.

Defines a selection of columns.

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.

Defines the identifiers for built-in data transformations.

Represents a DataTransformation that uses an ExpressionTransformation to exclude a set of columns.

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.

A wrapper for a number of simple DataTransformations. The wrapper uses ExpressionTransformation internally. Examples include AddCalculatedColumnTransformation and ChangeDataTypeTransformation.

Represents a DataTransformation that uses an ExpressionTransformation to only keep the rows that match the given Expression.

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.

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.

Represents a DataTransformation that uses an ExpressionTransformation to replace an existing column with a calculated column.

Represents a DataTransformation that replaces values on specific rows, or on a single specific row.

Represents a base class for the replace value transformations.

Represents a DataTransformation that replaces all values in a column that match a given value.

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.

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.