Fuzzy Match - Name Normalization

[Hammad_Rashid]

All,

Source data is in column "Company Name1". This includes list of similar names.

Requirement - Create a new column with clean names mapped against each source data entry.

How can we populate column "Company Name2" using Alteryx?

Some thoughts:

Firstly, we can find characters like "LLC, LLP, INC" and replace them with nothing.

Then, apply fuzzy match tool using some threshold. 

Could you guys please create a dynamic Alteryx workflow for this?

Thanks!

[Hammad_Rashid]

@binuacs @AndrewDMerrill @gawa @alexnajm 

[alexnajm · Accepted solution]

The Fuzzy Match tools has pre-processing built in to remove things like LLC, CO, etc. Here is a sample workflow that shows how I'd tackle this:

[Hammad_Rashid]

Thanks, @alexnajm 

Could you also please write some commentary for each step / tool?

I have always found fuzzy match confusing. Your explanation would be really helpful.

Thanks again.

Best,

Hammad

[alexnajm]

I don't necessarily want to just because it would take a while to type out but I think following along with the tools should indicate what the workflow is doing. More detail on the stages of Fuzzy Matching can be found here: Fuzzy Match Edit Match Options (alteryx.com)

There are also a lot of resources on the Community in this article: Tool Mastery | Fuzzy Match correspondance partielle fuzzyübereinstimmung (alteryx.com)

Thank you for marking the response as a solution, and good luck!