Fuzzy Match issues

[AustinRiggs94]

Hello All,

I have been reading and trying to learn how to fuzzy match. The issue is i have two inputs that i would like to match based on name rather than amount (see below). The amount can differ but date/name should align. I tried setting up the fuzzy match but i get 0 records.  Please let me know, thanks.

Input 1
Record ID	Date	Transaction	Amount	Description
40	2018-02-15	AT&T BILL PAYMENT	75	Description Input 1
41	2018-03-05	AVIS RENT-A-CAR 1	102.94	Description Input 2
42	2018-03-15	HILTON GARDEN INN ORLA	4.26	Description Input 3
44	2018-03-16	HILTON GARDEN INN ORLA	347.63	Description Input 4
53	2018-06-24	SEEHOTEL NIEDERNBERG	245.24	Description Input 5
55	2018-06-25	SEEHOTEL NIEDERNBERG	245.24	Description Input 6
57	2018-06-26	SEEHOTEL NIEDERNBERG	245.24	Description Input 7
58	2018-06-27	SEEHOTEL NIEDERNBERG	42.35	Description Input 8
59	2018-06-27	SEEHOTEL NIEDERNBERG	90.75	Description Input 9
Input 2
Record ID	Date	Transaction		Description
180	2018-02-15	AT&T*BILL PAYMENT	197.97	Description 2
184	2018-03-05	AVIS RENT-A-CAR 1,DENVER,CO,USA	205.88	Description 3
187	2018-03-16	HILTON GARDEN INN ORLA,ORLANDO,FL,USA	351.89	Description 4
202	2018-06-27	SEEHOTEL NIEDERNBERG,NIEDERNBERG,DEU,DEU	868.82	Description 5

[atrozz · Accepted solution]

Hello @AustinRiggs94. In this case, you need fuzzy match in merge mode because you have 2 fields. Look my example with you data, you need créate groups per fields and use unión, then apply fuzzy match with merge mode and only apply join to obtain differents fields.

Remember, look the configuration of fuzzy match tool. 

Regards!!!

[atrozz]

Sorry, idk why the message dont has the example.

Regards!!!