Alteryx Designer Desktop Discussions

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

Please help with Fuzzy Match.. Thank you.

florayaoyao
8 - Asteroid

Hi Alteryx Guru, 

 

I am pretty new to Alteryx....  

 

I am trying to do fuzzy match by the names. See below, I want to look the similarity between the column A and Column B. Could someone teach me how to set up the fuzzy match in Alteryx?  I am very confused by the parameters..please see below example that I used... not making sense... 

 

I need the match happen between the two values on the same row, and as output, it could give me a match score. For example, on the row 2, Harris Corporation and EVI INC should return a "0" Score. Also, the output should include both Column A and B, plus the score... 

 

Any help is very much appreciated! THANK YOU.. 

 

Flora 

 

 

 

Question 3.JPGQuestion 4.JPG

 

 

 

 

 

 

3 REPLIES 3
JordanB
Alteryx
Alteryx

Hi @florayaoyao

 

I have attached a workflow which walks through the 'Merge' principle of Fuzzy Matching. As you want to compare two different fields (e.g. two different sources) you will need to use two input tools, both will reference the same input file below, however in the first input tool you can just select the D&B Business Legal Name and in the second input tool you can use a select tool to choose the 'Aegis Orig Name' field. 

 

You can then follow the sample workflow below to compare the two field against one another. 

 

pic1.png

 

Best,

 

Jordan Barker

Solutions Consultant

florayaoyao
8 - Asteroid

Hi Jordan, 

 

This is Super!!  Thank you very much! Appreciate your help~~  :) 

 

Flora 

Aju_6
5 - Atom

It was a very helpful workflow. I was looking for the similar kind of a problem and your article helped me a lot. Thank you @florayaoyao 🙂 

Labels