/AWS1/CL_QSTUNPIVOTOPERATION¶
A transform operation that converts columns into rows, normalizing the data structure.
CONSTRUCTOR¶
IMPORTING¶
Required arguments:¶
iv_alias TYPE /AWS1/QSTXFRMOPERATIONALIAS /AWS1/QSTXFRMOPERATIONALIAS¶
Alias for this operation.
io_source TYPE REF TO /AWS1/CL_QSTXFRMOPSOURCE /AWS1/CL_QSTXFRMOPSOURCE¶
The source transform operation that provides input data for unpivoting.
it_columnstounpivot TYPE /AWS1/CL_QSTCOLUMNTOUNPIVOT=>TT_COLUMNTOUNPIVOTLIST TT_COLUMNTOUNPIVOTLIST¶
The list of columns to unpivot from the source data.
iv_unpivotedlabelcolumnname TYPE /AWS1/QSTCOLUMNNAME /AWS1/QSTCOLUMNNAME¶
The name for the new column that will contain the unpivoted column names.
iv_unpivotedlabelcolumnid TYPE /AWS1/QSTCOLUMNID /AWS1/QSTCOLUMNID¶
A unique identifier for the new column that will contain the unpivoted column names.
iv_unpivotedvaluecolumnname TYPE /AWS1/QSTCOLUMNNAME /AWS1/QSTCOLUMNNAME¶
The name for the new column that will contain the unpivoted values.
iv_unpivotedvaluecolumnid TYPE /AWS1/QSTCOLUMNID /AWS1/QSTCOLUMNID¶
A unique identifier for the new column that will contain the unpivoted values.
Queryable Attributes¶
Alias¶
Alias for this operation.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ALIAS() |
Getter for ALIAS, with configurable default |
ASK_ALIAS() |
Getter for ALIAS w/ exceptions if field has no value |
HAS_ALIAS() |
Determine if ALIAS has a value |
Source¶
The source transform operation that provides input data for unpivoting.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_SOURCE() |
Getter for SOURCE |
ColumnsToUnpivot¶
The list of columns to unpivot from the source data.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_COLUMNSTOUNPIVOT() |
Getter for COLUMNSTOUNPIVOT, with configurable default |
ASK_COLUMNSTOUNPIVOT() |
Getter for COLUMNSTOUNPIVOT w/ exceptions if field has no va |
HAS_COLUMNSTOUNPIVOT() |
Determine if COLUMNSTOUNPIVOT has a value |
UnpivotedLabelColumnName¶
The name for the new column that will contain the unpivoted column names.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_UNPIVOTEDLABELCOLUMNNAME() |
Getter for UNPIVOTEDLABELCOLUMNNAME, with configurable defau |
ASK_UNPIVOTEDLABELCOLUMNNAME() |
Getter for UNPIVOTEDLABELCOLUMNNAME w/ exceptions if field h |
HAS_UNPIVOTEDLABELCOLUMNNAME() |
Determine if UNPIVOTEDLABELCOLUMNNAME has a value |
UnpivotedLabelColumnId¶
A unique identifier for the new column that will contain the unpivoted column names.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_UNPIVOTEDLABELCOLUMNID() |
Getter for UNPIVOTEDLABELCOLUMNID, with configurable default |
ASK_UNPIVOTEDLABELCOLUMNID() |
Getter for UNPIVOTEDLABELCOLUMNID w/ exceptions if field has |
HAS_UNPIVOTEDLABELCOLUMNID() |
Determine if UNPIVOTEDLABELCOLUMNID has a value |
UnpivotedValueColumnName¶
The name for the new column that will contain the unpivoted values.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_UNPIVOTEDVALUECOLUMNNAME() |
Getter for UNPIVOTEDVALUECOLUMNNAME, with configurable defau |
ASK_UNPIVOTEDVALUECOLUMNNAME() |
Getter for UNPIVOTEDVALUECOLUMNNAME w/ exceptions if field h |
HAS_UNPIVOTEDVALUECOLUMNNAME() |
Determine if UNPIVOTEDVALUECOLUMNNAME has a value |
UnpivotedValueColumnId¶
A unique identifier for the new column that will contain the unpivoted values.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_UNPIVOTEDVALUECOLUMNID() |
Getter for UNPIVOTEDVALUECOLUMNID, with configurable default |
ASK_UNPIVOTEDVALUECOLUMNID() |
Getter for UNPIVOTEDVALUECOLUMNID w/ exceptions if field has |
HAS_UNPIVOTEDVALUECOLUMNID() |
Determine if UNPIVOTEDVALUECOLUMNID has a value |