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.

2.0

Hierarchy (view full)

Methods

  • Casts this object to the specified type. Throws error on failure.

    Type Parameters

    • T1

      The target type of the cast.

    • T2

      The type of the object to cast.

    Parameters

    Returns T1

  • Determines whether the specified object is equal to the current object.

    Parameters

    • obj: any

      The object to compare with the current object.

    Returns boolean

    true if the specified object is equal to the current object; otherwise, false.

  • Serves as the default hash function.

    Returns number

    A hash code for the current object.

  • Returns a string that represents the current object.

    Returns string

    A string that represents the current object.

  • Casts this object to the specified type. Returns null on failure.

    Type Parameters

    • T1

      The target type of the cast.

    • T2

      The type of the object to cast.

    Parameters

    Returns null | T1

  • Determines whether the specified object instances are considered equal.

    Parameters

    • objA: any

      The first object to compare.

    • objB: any

      The second object to compare.

    Returns boolean

    true if the objects are considered equal; otherwise, false. If both objA and objB are null, the method returns true.

Default capability

  • get Name(): string
  • Gets the display name of the transformation.

    Returns string

    2.0

  • get TypeId(): TypeIdentifier
  • Gets the type identifier for the data source.

    Returns TypeIdentifier

    2.0

  • get WhereClause(): string
  • Gets or sets the where clause expression. The transformation will only keep rows that match this boolean expression.

    Returns string

    2.0

  • set WhereClause(value): void
  • Parameters

    • value: string

    Returns void

  • get ColumnNameSymbol(): string
  • Use this in expressions and/or names to refer to the columns in a selection that this shall be applied to.

    Returns string

    2.0