Articles in this section

See more

Select/Cut Fields - "select"

Avatar
Tom Sherwood
  • Updated
Follow

Select rows that meet a condition.

Example 1

select_example_1.png
Example Input 1
dim_A dim_B metric_1
AAA DDD 111
- EEE 222
CCC FFF 333
Example Output 1
dim_A dim_B metric_1
AAA DDD 111
CCC FFF 333

 

Example 2

 select_example_2.png

Example Input 2
dim_A dim_B metric_1
AAA DDD 111
- EEE 222
CCC FFF 333
Example Output 2
dim_A Dim_B metric_1
AAA DDD 111
- EEE 222
- GGG 444

I Ain't Afraid of No Code!

Example 1 
[
    [
        "select",
        {
            "complement": false,
            "subtable": null,
            "where": "{dim_A}",
            "_comment": null
        }
    ]
]

 

Example 2 
[
    [
        "select",
        {
            "complement": true,
            "subtable": null,
            "where": "{dim_B} == 'FFF'",
            "_comment": null
        }
    ]
]

param boolean complement: By default false, if true will return only the rows not matching the condition.

param str where: The condition which the rows should match to be returned.

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

param str missing: The value that should be used for fields that are not in the source file.

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

Related articles

Comments

0 comments

Article is closed for comments.