topic Re: How does the unique matching work in tFuzzymatch component? in Talend Studio

How does the unique matching work in tFuzzymatch component?

Anonymous — Mon, 26 Jun 2017 19:01:25 GMT

Hi all,

I am using the double metaphone method in tFuzzymatch component to compare a column from the main table with reference column from the lookup table. If the unique matching option is checked, the best matched result would be given in the final output. But may I know how the "unique matching" actually work? Why does it pick the one as the best matched? What is the algorithm/criteria for comparison behind it?

For example:

(unique matching is unchecked)

Words_Main | VALUE | MATCHING

Oakland County Sheriff | AKLN | Oakland Academy,Oakland International Academy

(unique matching is checked)

Words_Main | VALUE | MATCHING

Oakland County Sheriff | AKLN | Oakland Academy

Why "Oakland Academy" is better than "Oakland International Academy"?

Thank you very much!!

Re: How does the unique matching work in tFuzzymatch component?

cterenzi — Tue, 27 Jun 2017 14:12:50 GMT

It looks like the code iterates over the list of values until it finds a match, and then stops. So it returns the first match it finds and does not make any comparison between all possible matches to return the "best" match.

Re: How does the unique matching work in tFuzzymatch component?

Anonymous — Fri, 30 Jun 2017 20:20:37 GMT

oh, so talend define the first match as the "best" one in tfuzzymatch? Is there anyway I can see the source code for this component? thanks

Re: How does the unique matching work in tFuzzymatch component?

cterenzi — Sat, 01 Jul 2017 04:44:51 GMT

Drop the component in a job, configure it, then click on the code tab under the job area.

Re: How does the unique matching work in tFuzzymatch component?

Anonymous — Mon, 03 Jul 2017 04:04:03 GMT

Hello,

Next to the Designer tab there is a Code tab that lets you view the source code for the entire Job. Or else there is Code view next to the Outline that shows the generated code for the selected component.

Best regards

Sabrina