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

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.