This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
The closest thing I could find was the Summarize Tool, but it doesn't let me specify a priority list for one of the keys. It only allows min, max, first, last, mode....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.