Fuzzy match workflow help

Question

Hello, hope you are doing well & thanks in advance.

I believe people likely already have workflows on Fuzzy Match, so I was hoping someone could share one that does the following:

I have 2 separate files both with a list of company names. I essentially want a workflow that can compare File 2 against the list in File 1 and then output the names from File 2 next to the File 1 that match with accuracy above 80%.

The output file would be:

* Column A - full list of File 1 company names
* Column B - respective FuzzyMatch company from File 2 (with accuracy above 80%) -- blank for ones that did not receive a match
* Column C - match score

Thanks in advance -- I tried playing around but was having difficulty producing the above

datausernyc0419 · Answer

Bump on this thread if anyone has any advice

datausernyc0419 · Answer

Thanks for this -- any ways to simplify the workflow / adjust it for larger datasets?

For reference, DataSet 1 is 3K companies but it is looking at a list of ~2M companies to match off of, and my Alteryx workflow is running forever / sometimes Alteryx just quits. Any advice?

CoG · Answer

Here is sample workflow that does what you were mentioning:

Sample Workflow.yxmd