Fuzzy Match Merge Mode against two Data Sources

[Masond3]

HI All, 

I have two data sources and i would like build a workflow which uses the fuzzy match algorithm and match percentages (100% -> 95% -> 90% -> 85% -> 80%) against a given record. 

I have attached my flow but at the moment i am not getting any results ( i am obviously doing something fundamentally wrong) 

Data Source 1 

Company ID (Long)	Company Name	Primary Address Line 1	Primary Address Line 2	Primary Address Line 3	City	Zip/Postal Code	State/Province	Country
001f100001LcrEDAAZ	Mason LTD	Av de Miremont 16	-	-	Genève	1206	-	Switzerland

Data Source 2

lei:LEI	LegalName	FirstAddressLine	AdditionalAddressLine	City	PostalCode	Region	Right_Country
5067002PTFI40N9JMB37	Mason LTD	avenue de Miremont 16		Genève	1206	CH-GE	Switzerland

Data Source 1	Data Source 2
Company Name	LegalName
Primary Address Line 1	FirstAddressLine
Primary Address Line 2
Primary Address Line 3
City	City
Zip/Postal Code	PostalCode
State/Province
Country	Right_Country
Company ID (Long)
	Region
	lei:LEI
	AdditionalAddressLine

Using the Example Above ;

Company Name ,City Zip & Country Match (but the Primary Address Line 1 has an abbreviated word from "Avenue to Av")

Looking forward to your assistance 

Many thanks 
Masond3

[BrandonB]

Hi @Masond3 

For fuzzy matching using the merge mode, there are a couple of things that you need to do first to prepare your data. Here is an example workflow and you should be able to adapt the steps to your data sets. I have also attached the workflow to this post.

 

You may also find this recorded training helpful: https://community.alteryx.com/t5/Videos/Fuzzy-Matching-for-Beginners/td-p/330575