Select/Cut Fields - "selectnotnone" – adverity Help Center

Selects rows within a single field column that contain any value (i.e. are not empty).

This is the inverse function of selectnone.

Example Input 1

Example Output 1

This example stresses the fact that "0" will never be counted as an empty field.

Example Input 2

Example Output 2

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.

Select/Cut Fields - "selectnotnone"