Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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