Hi All,
I have a table A with below columns and values,
Region | Company_Name | Category |
APAC | Toll Holdings Inc. | N |
APAC | BLUESCOPE STEEL LIMITED | N |
APAC | Visy Industries Australia Pty Ltd | N |
APAC | Sydney Water Corporation | G |
APAC | Adelaide Bank Limited | G |
And I have a lookup as below,
Account_Name | Domain |
Adelaide Bank | adelaidebank.com |
BLUESCOPE STEEL LIMITED | bluescopesteel.com |
Charles Schwab | schwab.com |
Coles Supermarkets Australia Pty Ltd. | coles.com |
EnergyAustralia | energyaustralia.com |
Old National Bancorp | oldnational.com |
Sydney Water | sydneywater.com.au |
Toll Holdings Limited | tollgroup.com |
Visy | visy.com.au |
How to use Fuzzy matching to match the Company_name and Account_name and append the other lookup columns as below table:
Region | Company_Name | Category | Account_Name | Domain |
APAC | Toll Holdings Inc. | N | Toll Holdings Limited | tollgroup.com |
APAC | BLUESCOPE STEEL LIMITED | N | BLUESCOPE STEEL LIMITED | bluescopesteel.com |
APAC | Visy Industries Australia Pty Ltd | N | Visy | visy.com |
APAC | Sydney Water Corporation | G | Sydney Water | sydneywater.com |
APAC | Adelaide Bank Limited | G | Adelaide Bank | adelaidebank.com |
Will Fuzzy match tool can be used, or is there any other method to do this.. Please help.
Thanks in Advance.
Preethi
Solved! Go to Solution.
Hi @preethisisaac ,
Yes, Fuzzy Match can be used to do this. It's not an easy tool to use, however. It will take some time to learn how to use it.
Here are some great free resources from Alteryx:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta-p/45485
Hi @preethisisaac - I like to do Exact Matching every time when possible. Only if all other options do not work I apply Fuzzy Matching. In any case I've built a solution for you. Hope it will work for you. Please see below:
Hi @preethisisaac - If the workflow worked for you, can you please mark it as a solution to let other community members to benefit from it?
Thanks a lot!!! it worked.