Ensures presence of columns in an extract. Adds missing columns with optional value. Default is None.
Example
Example Input
| dim_A | dim_B | metric_1 |
| AAA | DDD | 111 |
| BBB | EEE | 222 |
| CCC | FFF | 333 |
Example Output
| dim_A | dim_B | metric_1 | guaranteed_field_1 | guaranteed_field_2 |
| AAA | DDD | 111 | new_value | new_value |
| BBB | EEE | 222 | new_value | new_value |
| CCC | FFF | 333 | new_value | new_value |
I Ain't Afraid of No Code!
[
[
"extendmissing",
{
"subtable": null,
"fieldnames": [
"guaranteed_field_1",
"guaranteed_field_2"
],
"missing": "new_value"
"_comment": null
}
]
]param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param list fieldnames: Columns to be checked for existence.
param str missing: Value for newly created columns.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.