Icon

S5-04-Uniqueness

Duplicated input(Rows: 1060, Columns: 17)
Excel Reader
Remove exact duplicates
Duplicate Row Filter
Preview duplicated full namesfor correction
Table View
Export uniqueness dataset
Excel Writer
Keep onlyoriginal columns
Column Filter
Create full name
Expression
Group: full nameAggregation: COUNT(Record IDs)UNIQUE COUNT(National IDs)
GroupBy
Create employment status rank:ACTIVE = 2LEAVE = 1TERMINATED = 0
Expression
Return full-row details for Unique records
Reference Row Filter
Split records into unique full names(Unique count=1) and duplicated full names(Unique count<>1).
Row Splitter
Return full-row details for duplicated full names
Reference Row Filter
Key Priorities:1) Ascending national IDs2) Descending status ranks3) Descending hire date4) Descending last update
Sorter
Remove duplicated national IDs by previous sorting rules
GroupBy

Nodes

Extensions

Links