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
Labels