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!
Solved! Go to Solution.
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
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!