Select rows that meet a condition.
Example 1

Example Input 1
dim_A | dim_B | metric_1 |
AAA | DDD | 111 |
- | EEE | 222 |
CCC | FFF | 333 |
Example Output 1
dim_A | dim_B | metric_1 |
AAA | DDD | 111 |
CCC | FFF | 333 |
Example 2
Example Input 2
dim_A | dim_B | metric_1 |
AAA | DDD | 111 |
- | EEE | 222 |
CCC | FFF | 333 |
Example Output 2
dim_A | Dim_B | metric_1 |
AAA | DDD | 111 |
- | EEE | 222 |
- | GGG | 444 |
I Ain't Afraid of No Code!
Example 1[
[
"select",
{
"complement": false,
"subtable": null,
"where": "{dim_A}",
"_comment": null
}
]
]
Example 2
[
[
"select",
{
"complement": true,
"subtable": null,
"where": "{dim_B} == 'FFF'",
"_comment": null
}
]
]
param boolean complement: By default false, if true will return only the rows not matching the condition.
param str where: The condition which the rows should match to be returned.
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str missing: The value that should be used for fields that are not in the source file.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.