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.

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 CategorySeparator(): string
  • The category separator to be used when combining category values for value column names.

    Returns string

    2.0

  • set CategorySeparator(value): void
  • Parameters

    • value: string

    Returns void

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

    Returns string

    2.0

  • get ResultNamingExpression(): string
  • Naming expression for the aggregated result data columns. This naming expression is a string containing a placeholder to be replaced with values during Pivot as follows:
    %M is replaced with the aggregation method name (empty string for None).
    %V is replaced with the value column name.
    %C is replaced with a concatenated list of category values separated by Category separator.

    Returns string

    2.0

  • set ResultNamingExpression(value): void
  • Parameters

    • value: string

    Returns void

  • get TransferNamingExpression(): string
  • Naming expression for the aggregated transfer result columns. This naming expression is a string containing a placeholder to be replaced with values during Pivot as follows:
    %A is replaced with the aggregation method name (empty string for None).
    %T is replaced with the transfer value column name.

    Returns string

    2.0

  • set TransferNamingExpression(value): void
  • Parameters

    • value: string

    Returns void

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

    Returns TypeIdentifier

    2.0