Select rows where given expression evaluates as false. This function is the opposite of select.
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 |
| AAA | DDD | 111 |
| CCC | FFF | 333 |
I Ain't Afraid of No Code!
[
[
"selectfalse",
{
"complement": false,
"subtable": null,
"field": "{metric_1} % 2 == 0",
"_comment": null
}
]
]param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str field: Field from which to select false values.
param boolean complement: By default false, if true will return only the rows not matching the condition.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.