Fuzzy match - Only keep record with highest match score

[YanishDewan]

Hi 

I have ran a fuzzy match process (Merge mode) which compares company name from source 1 to a master company table (source 2) and my output after elimination duplicates contains the following:

Invoice Number	Company Name	Match score
1	ABC (UK) Ltd	100
1	ABC (IE) Ltd	91
2	XYZ Ltd	92
3	DEF Ltd	93

How can I use Alteryx to eliminate the duplicate on Invoice 1 to keep only the match with highest score? The desired output table is:

Invoice Number	Company Name	Match score
1	ABC (UK) Ltd	100
2	XYZ Ltd	92
3	DEF Ltd	93

[Jonathan-Sherman · Accepted solution]

Hi @YanishDewan,

You could use the sample tool to group by invoice number and keep the first record:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan