Merges 1 + nrows and fills missing values depending on direction. Default direction is downwards.
Example
Example Input
| dim_A | dim_B | metric_1 |
| AAA | DDD | 111 |
| BBB | EEE | 222 |
| CCC | FFF | 333 |
Example Output
| dim_A-AAA | dim_B-DDD | metric_1-111 |
| BBB | EEE | 222 |
| CCC | FFF | 333 |
I Ain't Afraid of No Code!
[
[
"mergeheader",
{
"nrows": 1,
"fillright": false,
"joinchar": " -",
"subtable": null,
"_comment": null
}
]
]
param str nrows: Amount of rows that shall be considered additionally to first row.
param boolean fillright: If true, direction to fill = right.
param str joinchar: String to be used for concatenating row values.
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.