Select rows where given field is contained in value table.
Example
Using the following Value Table:
Example Input
Values |
BBB |
CCC |
dim_A | dim_B | metric_1 |
AAA | DDD | 111 |
BBB | EEE | 222 |
CCC | FFF | 333 |
Example Output
dim_A | Dim_B | metric_1 |
BBB | EEE | 222 |
CCC | FFF | 333 |
I Ain't Afraid of No Code!
[
[
"selectinvt",
{
"subtable": null,
"value_table_name": "Values",
"fieldname": "dim_A",
"_comment": null
}
]
]
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str value_table_name: Value table used for selection.
param str fieldname: Field to be compared with values from value_table_name.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.