Alteryx Designer Desktop Discussions

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

Help for Fuzzy match

vishwa1979
7 - Meteor

Dear Team,

 

I want to do fuzzy match between two columns in different sheet.

Please help.

Columns to be consider as below

 

PT DESC - Sales sheet

Full Name - Master Sheet

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hey @vishwa1979 ,

 

Here is an example for you.

Screenshot 2023-07-13 152404.png

 

As with any statistical method, fuzzy matching is not a 100% accurate process and it could require some manual work. 

I suggest you take a look at the following materials to learn more about how to improve the accuracy or to select the best options to work with your data.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Tool-Mastery-Fuzzy-Match/ta...

https://help.alteryx.com/20231/designer/fuzzy-match-tool

 

Best,

Fernando Vizcaino

Labels