Select rows with duplicate values under a given key. All unique rows are discarded.
Example 1
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
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.
Comments
0 comments
Article is closed for comments.