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 |
Solved! Go to 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