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

Question

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!

Vendor - Secondary.xlsx

Customer - Main.xlsx

Desired Output.xlsx

pedrodrfaria · Answer

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.

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

tyreenugen · Answer

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.

Luke_C · Answer

@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

New Workflow3.yxmd