Articles in this section

See more

Select/Cut Fields - "selecteq"

Avatar
Tom Sherwood
  • Updated
Follow

Select rows where the given field equals the given value.

 

Example 1

selecteq_example_1.png

Example Input 1
dim_A dim_B metric_1
AAA DDD 111
BBB EEE 222
CCC FFF 333
 Example Output 1
dim_A dim_B metric_1
CCC FFF 333

 

Example 2

selecteq_example_2.png

Example Input 2
dim_A dim_B metric_1
AAA DDD 111
BBB EEE 222
CCC FFF 333
 Example Output 2
dim_A dim_B metric_1
BBB EEE 222
CCC FFF 333

 

I Ain't Afraid of No Code!

Example 1 
[
    [
        "selecteq",
        {
            "complement": false,
            "subtable": null,
            "field": 0,
            "value": "CCC",
            "_comment": null
        }
    ]
]
Example 2 
[
    [
        "selecteq",
        {
            "complement": true,
            "subtable": null,
            "field": 1,
            "value": "DDD",
            "_comment": null
        }
    ]
]

param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).

param str field: The field that is to be checked, can be an index of it.

param str value: The value that is to be exactly matched in the field.

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.

Related articles

Comments

0 comments

Article is closed for comments.