Fuzzy Match Case

[bpatel1]

Hi guys,

I was trying to solve the below problem using fuzzy match. I want to find companies from AI dataset with S dataset. Then removing duplicates in source S. 

I created workflow using Fuzzy match but it seems not working. I found few companies were left out even they have common names in both sources. 

Thanks in advance.  

[ChrisTX]

Common names in both sources won't necessarily lead to a fuzzy match.  First, the keys must match.

At the bottom left, under Advanced Options, check the option for Output Generated Keys.  For those records you think should match, are the keys the same?

Take a look at these videos:

Fuzzy Matching for Beginners 2018-12-11
https://community.alteryx.com/t5/Videos/Fuzzy-Matching-for-Beginners/td-p/330575

Introduction to Fuzzy Matching 2016-12-13
https://community.alteryx.com/t5/Videos/Introduction-to-Fuzzy-Matching/td-p/43884

Fuzzy Matching Intermediate Users 2016-07-26
https://community.alteryx.com/t5/Videos/Fuzzy-Matching-Intermediate-Users/td-p/43852

Here's a list of all videos: https://community.alteryx.com/t5/Videos/bd-p/live-training

  The first link is the Video Training Index: https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161

Chris

[randreag]

hi @bpatel1 

you didn't attached the dataset or the workflow

[bpatel1]

Sorry, it has some confidential info. Let me cleanup and add into this. 

[bpatel1]

The workflow attached below. 

basically, I have to dedup the data from S-source by bringing all the match cases from AI - Source data. 

[bpatel1]

Just wondering if anyone tried and found the success. Please keep me posted. 

[ChrisTX]

You attached the workflow (yxmd) file, so we don't have these 2 input files:

S data.xlsx

AI data.xlsx

In Alteryx Designer, under the menu item for Options , use Export Workflow to package your workflow and input files into a single zip file (yxzp) and attach that zip file to this thread.

Chris

[bpatel1]

Sorry, here you go! 

[ArtApa]

Hi @bpatel1 - I changed a few things in your workflow:

1) Record ID for AI now starts from 100,000. You do want it to be unique.

2) Record ID field in the Fuzzy Match tool must be Record ID

3) Match Style basis is Company Name.

4) You may now change the Threshold in both Fuzzy Match tool and Match Style to tune how many records you want to match.

5) Finally, you do want to remove duplicate matches. I added a Unique tool

[bpatel1]

Hi ArtApa,

Thanks for your help.