compare data from two excel files, perform fuzzy match, and generate scores

[tyreenugen]

Hi,

I have two files (Customer and Vendors) that I want to perform fuzzy matching on and then calculate the similarity score between the two sources. any record with a score above 80% will be returned as an output. is this doable in Alteryx? Please see the excel files for references. thanks alot in advance for your help!

[AngelosPachis]

Hi @tyreenugen ,

Can you please elaborate a bit more about the logic behind the 85% score? How did you get that figure?

Thanks,

Angelos

[Luke_C]

@tyreenugen 

Here's a quick mock-up of how this could be done. 

Additional info on fuzzy matching:

https://help.alteryx.com/current/designer/fuzzy-match-tool

[tyreenugen]

I randomly came up with the score. 🙂 I have the IDEA application on my system and I'm pretty sure that if i do the fuzzy matching with it, the score will be above 80% based on the similarity of the names. 

[pedrodrfaria]

Hi @tyreenugen 

I added below the WF being shown below. It covers how to apply fuzzy matching while joining different datasets (Merge Mode)

Please let me know if you have questions.