Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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