/AWS1/CL_QSTPIVOTOPERATION¶
A transform operation that pivots data by converting row values into columns.
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 pivoting.
io_valuecolumnconfiguration TYPE REF TO /AWS1/CL_QSTVALUECOLUMNCONF /AWS1/CL_QSTVALUECOLUMNCONF¶
Configuration for how to aggregate values when multiple rows map to the same pivoted column.
io_pivotconfiguration TYPE REF TO /AWS1/CL_QSTPIVOTCONFIGURATION /AWS1/CL_QSTPIVOTCONFIGURATION¶
Configuration that specifies which labels to pivot and how to structure the resulting columns.
Optional arguments:¶
it_groupbycolumnnames TYPE /AWS1/CL_QSTPIVOTGRBYCOLUMNN00=>TT_PIVOTGROUPBYCOLUMNNAMELIST TT_PIVOTGROUPBYCOLUMNNAMELIST¶
The list of column names to group by when performing the pivot operation.
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 pivoting.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_SOURCE() |
Getter for SOURCE |
GroupByColumnNames¶
The list of column names to group by when performing the pivot operation.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_GROUPBYCOLUMNNAMES() |
Getter for GROUPBYCOLUMNNAMES, with configurable default |
ASK_GROUPBYCOLUMNNAMES() |
Getter for GROUPBYCOLUMNNAMES w/ exceptions if field has no |
HAS_GROUPBYCOLUMNNAMES() |
Determine if GROUPBYCOLUMNNAMES has a value |
ValueColumnConfiguration¶
Configuration for how to aggregate values when multiple rows map to the same pivoted column.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_VALUECOLUMNCONFIGURATION() |
Getter for VALUECOLUMNCONFIGURATION |
PivotConfiguration¶
Configuration that specifies which labels to pivot and how to structure the resulting columns.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_PIVOTCONFIGURATION() |
Getter for PIVOTCONFIGURATION |