Skip to main content

Doing a fuzzy match on two columns and outputting the main and rejected data

Availability-noteDeprecated
Information noteImportant: The tFuzzyJoin component is deprecated since the 6.0 General Availability release and removed from Talend Studio 8.0 R2024-05 onwards. Talend recommends to use the tRecordMatching component.

This scenario applies only to Talend Data Management Platform, Talend Big Data Platform, Talend Real-Time Big Data Platform, Talend MDM Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric.

This scenario describes a five-component Job aiming at: first checking the edit distance between the IdClient column of an input file against the data of the reference input file, and second checking all emails by their pronunciation in the Email column against the data of the reference input file. The outputs of these two matching types are written in two separate files.

In this scenario, we have already stored the input schemas of the input and reference files in the Repository. For more information about storing schema metadata in the Repository tree view, Managing metadata in Talend Studio.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!