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.
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
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?
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
