The Spotfire.Dxp.Data.Transformations namespace contains classes for transforming imported data.
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.
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.
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 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.