Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Fuzzy Match 2 Columns with score

Lauritsjust
7 - Meteor

Hi All

I am using the solution provided in Comparing Records between two columns for similarity

 

However, the solution is not quite what I am looking for. The solution provided only looks up the pairs provided in Field1 and Field2, where i would like the solution to find the "highest" match from field 1 and field 2. 

Input:

Lauritsjust_2-1644228406832.png

 

 

Output:

Lauritsjust_3-1644228418711.png

 

 

Desired output: 

Lauritsjust_4-1644228620963.png

 

 

 

I would like the result to show me that (Field1:8) and (Field2:5) are almost the same, and the names can thus be corrected in my full dataset. 

 

I also need to filter for unique values.

Any ideas?

0 REPLIES 0
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels