In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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