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.
Inheritance Hierarchy
Spotfire.Dxp.DataDataTransformation
Spotfire.Dxp.Data.TransformationsExpressionTransformation
Namespace: Spotfire.Dxp.Data.Transformations
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 69.0.21424.2902 (69.0.21424.2902)
Syntax
C#
[SerializableAttribute] [PersistenceVersionAttribute(37, 0)] public sealed class ExpressionTransformation : DataTransformation
The ExpressionTransformation type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
| ExpressionTransformation |
Creates the transformation.
|
Properties
| Name | Description | |
|---|---|---|
| ColumnAdditions |
Gets the collection of operations that represents added columns.
| |
| ColumnNameSymbol |
Use this in expressions and/or names to refer to the columns in a selection that this shall be applied to.
| |
| ColumnRemovals |
Gets the collection of operations that represents removed columns.
| |
| ColumnReplacements |
Gets the collection of operations that represents replaced columns.
| |
| LoadReport | Gets the PartialDataLoadReport that can be used to
report errors during connection.
(Inherited from DataTransformation.) | |
| Name | Gets the display name of the transformation.
(Inherited from DataTransformation.) | |
| TypeId | Gets the type identifier for the data source.
(Inherited from DataTransformation.) | |
| WhereClause |
Gets or sets the where clause expression.
The transformation will only keep rows that match this boolean expression.
|
Methods
| Name | Description | |
|---|---|---|
| Connect | Connects to the input reader.
A DataRowReader can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.) | |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) | |
| GetHashCode | Serves as the default hash function. (Inherited from Object.) | |
| GetType | Gets the Type of the current instance. (Inherited from Object.) | |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
| ISerializableGetObjectData |
Implements ISerializable.
(Inherited from DataTransformation.) |
Version Information
Supported in: 14.7, 14.6, 14.5, 14.4, 14.3, 14.2, 14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0, 11.8
See Also