Fuzzy matching

[Phil_Wainman]

Hi - new to Alteryx, so apologies for hopefully a simple question.  I have a free type list of company names that I need to clean and standardise.  What would be the best approach. I was thinking of using the Fuzzy Match function?  (List too long to manually correct!)

[BenMoss · Accepted solution]

The fuzzy match tool would definitely be something to investigate, and this blog is a great starting point:

https://www.theinformationlab.co.uk/2014/04/02/alteryx-tools-focus-fuzzy-match-make-group-unique/

However, sometime's you may want to just apply a standard set of business rules to try and match the values, which you can relay to your end users.

Ben