Unpack data values from lists or tuples.
Example
Example Input
| dim_A | dim_B | metric_1 | structure_1 |
| AAA | DDD | 111 | [3, 4, 5, 6] |
| BBB | EEE | 222 | ([1, 2, 3], [3, 2, 1]) |
Example Output
| dim_A | dim_B | metric_1 | structure_1 | new_1 | new_2 | new_3 | new_4 |
| AAA | DDD | 111 | [3, 4, 5, 6] | 3 | 4 | 5 | 6 |
| BBB | EEE | 222 | ([1, 2, 3], [3, 2, 1]) |
[1, 2, 3] | [3, 2, 1] | missing | missing |
I Ain't Afraid of No Code!
[
[
"unpack",
{
"subtable": null,
"includeoriginal": true,
"newfields": [
"new_1",
"new_2",
"new_3",
"new_4"
],
"field": "structure_1",
"missing": "missing",
"_comment": null
}
]
]param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param boolean includeoriginal: Retain source field. Defaults to false.
param list newfields: Names resulting fields. In case values > result_fields, remaining values won’t be unpacked. In case values < result_fields, missing values will be used.
param str field: Name of field to be unpacked.
param str missing: Autofill values for missing fields.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.