Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fuzzy Matching Lookup

preethisisaac
8 - Asteroid

Hi All,

I have a table A with below columns and values,

RegionCompany_NameCategory
APACToll Holdings Inc.N
APACBLUESCOPE STEEL LIMITEDN
APACVisy Industries Australia Pty LtdN
APACSydney Water CorporationG
APACAdelaide Bank Limited

G

 

And I have a lookup as below,

Account_NameDomain
Adelaide Bankadelaidebank.com
BLUESCOPE STEEL LIMITEDbluescopesteel.com
Charles Schwabschwab.com
Coles Supermarkets Australia Pty Ltd.coles.com
EnergyAustraliaenergyaustralia.com
Old National Bancorpoldnational.com
Sydney Watersydneywater.com.au
Toll Holdings Limitedtollgroup.com
Visyvisy.com.au

 

How to use Fuzzy matching to match the Company_name and Account_name and append the other lookup columns as below table:

RegionCompany_NameCategoryAccount_NameDomain
APACToll Holdings Inc.NToll Holdings Limitedtollgroup.com
APACBLUESCOPE STEEL LIMITEDNBLUESCOPE STEEL LIMITEDbluescopesteel.com
APACVisy Industries Australia Pty LtdNVisyvisy.com
APACSydney Water CorporationGSydney Watersydneywater.com
APACAdelaide Bank LimitedGAdelaide Bankadelaidebank.com

 

Will Fuzzy match tool can be used, or is there any other method to do this.. Please help.

 

Thanks in Advance.

Preethi

 

4 REPLIES 4
mbarone
16 - Nebula
16 - Nebula

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

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Prepare-two-inputs-for-Fuzzy-Match-...

 

ArtApa
Alteryx
Alteryx

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:

 

ArtApa_0-1614973209723.png

 

ArtApa
Alteryx
Alteryx

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?

preethisisaac
8 - Asteroid

Thanks a lot!!! it worked.

Labels