De-duplication Priority

[wichov]

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

[wichov]

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....