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?
