Class UnpivotTransformation

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.

Since

2.0

Hierarchy (view full)

Methods

Cast Equals GetHashCode ToString TryCast Equals

Default capability

constructor CategoryName CategoryType IdentityColumns Name RemoveNull ResultName ResultType TypeId ValueColumns Connect

Methods

Cast

  • Cast<T1, T2>(this, type): T1

  • 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

Equals

  • Equals(obj): boolean

  • 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.

GetHashCode

  • GetHashCode(): number

  • Serves as the default hash function.

    Returns number

    A hash code for the current object.

ToString

  • ToString(): string

  • Returns a string that represents the current object.

    Returns string

    A string that represents the current object.

TryCast

  • TryCast<T1, T2>(this, type): null | T1

  • 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

StaticEquals

  • Equals(objA, objB): boolean

  • 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

constructor

CategoryName

  • get CategoryName(): string

  • Name of the category column for merged column names.

    Returns string

    Since

    2.0

  • set CategoryName(value): void

  • Parameters

    • value: string

    Returns void

CategoryType

IdentityColumns

Name

  • get Name(): string

  • Gets the display name of the transformation.

    Returns string

    Since

    2.0

RemoveNull

  • get RemoveNull(): boolean

  • Gets or sets whether null values shall be removed or not.

    Returns boolean

    Since

    2.0

  • set RemoveNull(value): void

  • Parameters

    • value: boolean

    Returns void

ResultName

  • get ResultName(): string

  • Name of the result column holding the merged value column data.

    Returns string

    Since

    2.0

  • set ResultName(value): void

  • Parameters

    • value: string

    Returns void

ResultType

TypeId

  • get TypeId(): TypeIdentifier

  • Gets the type identifier for the data source.

    Returns TypeIdentifier

    Since

    2.0

ValueColumns

Connect

Settings

Member Visibility

On This Page

Methods
Default capability