Articles in this section

See more

Select/Cut Fields - "duplicates"

Avatar
Tom Sherwood
  • Updated
Follow

Select rows with duplicate values under a given key. All unique rows are discarded.

Example 1

duplicates_example.png

Example Input 1
dim_A dim_B metric_1
AAA DDD 111
AAA DDD 111
AAA DDD 222
BBB EEE 333
BBB FFF 444
CCC GGG 555
CCC GGG 666
CCC HHH 777
Example Output 1
dim_A dim_B metric_1
AAA DDD 111
AAA DDD 111
AAA DDD 222
CCC GGG 666
CCC GGG 777

 

Example 2

duplicates_example_2.png

Example Input 2
dim_A dim_B metric_1
AAA DDD 111
AAA DDD 111
AAA DDD 222
BBB EEE 333
BBB FFF 444
CCC GGG 555
CCC GGG 666
CCC HHH 777
Example Output 2
dim_A dim_B metric_1
AAA DDD 111
AAA DDD 111

 

I Ain't Afraid of No Code!

Example 1 
[
    [
        "duplicates",
        {
            "subtable": null,
            "presorted": false,
            "key": [
                "dim_A",
                "dim_B"
            ],
            "_comment": null
        }
    ]
]

 

Example 2 
[
    [
        "duplicates",
        {
            "subtable": null,
            "presorted": false,
            "key": null,
            "_comment": null
        }
    ]
]

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

param list key: The (optional) field key(s).

param boolean presorted: Default is false.

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

Related articles

Comments

0 comments

Article is closed for comments.