Fuzzy Lookup Similar to Excel

JDaviesInch

Hi,

I have some data from the internet which isnt't very clean and I would usually do a Fuzzy lookup in Excel to determine any close matches.

I have included some Sample data whereby I am trying to get the closest match between Column J of the Example Lookup Data and Column D of the Internet Data. The sample Data is only for a couple of Vehicle Models but this would need to dynamic for other brands/models. I would like to then be able to add the Vehicle ID to the Internet data example file.

Is there any way I can replicate this in Alteryx? 

Thank You

Example Lookup Data.xlsx

InternetDataExample.xlsx

echuong1

Try using the Fuzzy Match capability! This is sometimes more of an art than a science, but you can test out different configurations and match thresholds.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485