Selects rows within a single field column that contain any value (i.e. are not empty).
Example 1
Example Input 1
dim_A | dim_B | metric_1 |
AAA | DDD | 0 |
EEE | 222 | |
CCC | FFF |
Example Output 1
dim_A | dim_B | metric_1 |
AAA | DDD | 0 |
CCC | FFF |
Example 2
This example stresses the fact that "0" will never be counted as an empty field.
Example Input 2
dim_A | dim_B | metric_1 |
AAA | DDD | 0 |
EEE | 222 | |
CCC | FFF |
Example Output 2
dim_A | Dim_B | metric_1 |
AAA | DDD | 0 |
EEE | 222 |
I Ain't Afraid of No Code!
Example 1[
"selectnotnone",
{
"complement": false,
"subtable": null,
"field": "dim_A",
"_comment": null
}
]
Example 2
[
"selectnotnone",
{
"complement": false,
"subtable": null,
"field": "metric_1",
"_comment": null
}
]
param boolean complement: By default false, if true will return only the rows not matching the condition.
param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).
param str field: The column field to be parsed.
param str comment: A comment that will appear in the Transformation UI.
Comments
0 comments
Article is closed for comments.