Action
    Preparing search index...

    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.

    If nothing but identity columns are specified, the result of this Pivot transformation will be the distinct values of the identity columns.

    If nothing but identity and transfer columns are specified, the result of this Pivot transformation will be an aggregation of the transfer columns over the identity columns.

    2.0

    Hierarchy (View Summary)

    Index

    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: string): 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: string): 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: string): void

      Parameters

      • value: string

      Returns void

    • get TypeId(): TypeIdentifier

      Gets the type identifier for the data source.

      Returns TypeIdentifier

      2.0