community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Join with dissimilar key (company name)

Trying to join data where the key is the company name - both are coming from different data sources, so no clean spelling of company name.  Love to apply a fuzzy match on company name during the join process.  Using Merge feature along with Fuzzy Match tool did not work.

Alteryx Certified Partner
Alteryx Certified Partner

Without address or other fields in the fuzzy match, I would caution your use of the fuzzy matching tool. As an example, crossroads mall Claire’s and crossroads mall Dick’s will likely join.

McDonalds 123 and McDonalds XYZ are another example of franchise names that might not be the same.

You’ll need to examine the records with your eyes and start from there.

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels