Setting up the Job - 7.0

Fuzzy matching

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
Data Quality and Preparation > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
Design and Development > Third-party systems > Data Quality components > Matching components > Fuzzy matching components
EnrichPlatform
Talend Studio

Procedure

  1. In the Repository tree view, expand Metadata and the file node where you have stored the input schemas and drop the relevant file onto the design workspace.
    The [Components] dialog box displays.
  2. Select tFileInputDelimited from the list and click OK to close the dialog box.
    The tFileInputDelimited component displays in the workspace. The input file used in this scenario is called ClientSample. It holds 12 columns including the two columns IdCient and Email we want to do the fuzzy match on.
  3. Do the same for the second input file you want to use as a reference, ClientSample_Update in this scenario.
  4. Drop the following components from the Palette onto the design workspace: tFuzzyJoin, tFileOutputExcel, and tFileOutputDelimited.
  5. Connect the main and reference input files to tFuzzyJoin using Main links. The link between the reference input file and tFuzzyJoin displays as a Lookup link on the design workspace.
  6. Connect tFuzzyJoin to tFileOutputExcel using the Main link and tFuzzyJoin to tFileOutputDelimited using the Inner join reject link.
  7. If needed, double-click the main and reference input files to display their Basic settings views. All their property fields are automatically filled in. If you do not define your input files in the Repository, fill in the details manually after selecting Built-in in the Property Type field.