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