community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

De-duplication Priority

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.

 

IDOriginField NameValue
1ANAMEJACK
1BNAMEPETER
1BZIP CODE15024
1CZIP CODE15024
1DTYPEMID
1HTYPE

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

1 Comment
Atom

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

Labels