topic Re: Using tFuzzyMatch in a lookup in Talend Studio

Using tFuzzyMatch in a lookup

Jj5 — Wed, 10 Feb 2016 20:28:03 GMT

I have two files, one is a main file with lots of fields. The second file is a lookup file which has company names and company codes. I need to add the company codes to the main file, however the company names are slightly different.

E.g.
Main File:
Company Name | Company Address | Company Phone

Cool Co, inc. | 123 Main St | 1234567890
Smooth Co | 111 Fun Rd | 1112223333

Lookup File:
Company Code | Company Name

1111 | Cool Co inc
1255 | Smooth co.

The expected output would be:
1111 | Cool Co, inc. | 123 Main St | 1234567890
1255 | Smoth Co | 111 Fun Rd | 1112223333

I have the tFuzzyMatch working, but it won't let me change the output schema, meaning that it only pulls the main file's fields. How do I add fields from the lookup file when there's a close match? If you look at the examples there are 2 small differences between the names so I can't do an exact link in a tMap.

Re: Using tFuzzyMatch in a lookup

Anonymous — Wed, 17 Feb 2016 08:14:55 GMT

Hi,
Have you tried to use TalendHelpCenter:tRecordMatching which joins two tables by doing a fuzzy match on several columns using a wide variety of comparison algorithms.
Best regards
Sabrina

Re: Using tFuzzyMatch in a lookup

Jj5 — Thu, 18 Feb 2016 15:42:17 GMT

xdshi wrote:
Hi,
Have you tried to use TalendHelpCenter:tRecordMatching which joins two tables by doing a fuzzy match on several columns using a wide variety of comparison algorithms.
Best regards
Sabrina

This component doesn't seem to be part of the Open Studio suite, is it only for the enterprise version?

Re: Using tFuzzyMatch in a lookup

Anonymous — Tue, 23 Feb 2016 10:38:19 GMT

Hi,
Indeed, it's not available in open source.

This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend Platform products.
Best regards
Sabrina