Articles in this section

See more

Select/Cut Fields - "selectinvt"

Avatar
Tom Sherwood
  • Updated
Follow

Select rows where given field is contained in value table.

Example

selectinvt_example.png

Using the following Value Table:
Values
BBB
CCC
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!

[
    [
        "selectinvt",
        {
            "subtable": null,
            "value_table_name": "Values",
            "fieldname": "dim_A",
            "_comment": null
        }
    ]
]

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

param str value_table_name: Value table used for selection.

param str fieldname: Field to be compared with values from value_table_name.

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

Related articles

Comments

0 comments

Article is closed for comments.