Articles in this section

See more

Select/Cut Fields - "selectgt"

Avatar
Tom Sherwood
  • Updated
Follow

Select rows where given field is greater than given value.

Example

selectgt_example.png

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
BBB EEE 222
CCC FFF 333

 

I Ain't Afraid of No Code!

[
    [
        "selectgt",
        {
            "complement": false,
            "subtable": null,
            "field": "metric_1",
            "value": "200",
            "_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: Field to be compared with value, ideally formatted as number.

param int value: Value used for comparison.

param str comment: A comment that will appear in the Transformation UI.

Related articles

Comments

0 comments

Article is closed for comments.