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 Matching with Custom Criteria

dte324
5 - Atom

I have two different datasets with different values. The one dataset serves as a lookup table for the other.

 

For example:

 

Name   Code

==========

Al         124.5

Bill        324.1

Cody    947.6

Dan      543.2

 

Code   Description

===============

121.4   qwerty

324.1   uiopas

899.7   dfghjk

555.6  lzxcvb

 

I want to perform a Fuzzy Match to join the two datasets. I'm not sure how to best merge the datasets before the Fuzzy Match since the columns are so different (like the above example). What is the best way to go about this? How should I customize the Fuzzy Match criteria?

0 REPLIES 0
Labels
Top Solution Authors