In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Fuzzy Match Two Lists

bperumal
5 - Atom

I want to compare two lists of company names, specifically one cell to the adjacent cell and tell if those two records are a match. Having trouble configuring the fuzzy match tool for this. 

 

Desired Result: 

 

Company NameAccount NameMatch Status
AppleApple IncMatch
YahooYahoo CorpMatch
Nestle USANestle UKMatch
Dunkin DonutsTim HortonsNo match 
2 REPLIES 2
putu_w_erata
8 - Asteroid

a bit messy but gets the job done :)

CoG
14 - Magnetar

Here is an alternative that's a little simpler, using a batch macro.

Main Workflow:

_Main Workflow.png

Macro:

_Macro.png

 

Happy Solving!!!

Labels
Top Solution Authors