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!

Fuzzy Match

Accepted answers

alexnajm

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:

Fuzzy Match.yxmd

All comments

Hammad_Rashid

@binu_acs @CoG @gawa @alexnajm

alexnajm

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:

Fuzzy Match.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703