Hello Community,
I was wondering if there is a tool that could de-duplicate records after serializing (or after using Transpose Tool) with a given priority for each field in one of the keys? i.e.
ID |
Origin |
Field Name |
Value |
1 |
A |
NAME |
JACK |
1 |
B |
NAME |
PETER |
1 |
B |
ZIP CODE |
15024 |
1 |
C |
ZIP CODE |
15024 |
1 |
D |
TYPE |
MID |
1 |
H |
TYPE |
PKL
|
Assuming for the field name NAME, the priority should be [ A, B ]
ZIP CODE -> [ C, B ]
TYPE -> [ H, D ]
The expected outcome for Id 1 should be -> JACK, 15024, PKL
Record discarded -> PETER, 15024, MID
In this case I'm using ID and Origin as keys in the Transpose Tool.
I just want to make sure there is no other route than the Python Tool.
Thank you
Luis