Grouping output data in separate flows according to the minimal distance computed in each record

Grouping output data in separate flows according to the minimal distance computed in each record - 7.0

Data matching

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

EnrichPlatform

Talend Studio

task

Data Governance > Third-party systems > Data Quality components > Matching components > Data matching components

Data Quality and Preparation > Third-party systems > Data Quality components > Matching components > Data matching components

Design and Development > Third-party systems > Data Quality components > Matching components > Data matching components

Subscription

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

For more technologies supported by Talend, see Talend components.

This scenario describes a basic Job that compares columns in the input file using the Jaro-Winkler matching method on the lname and fname column and the q-grams matching method on the address1 column. It then groups the output records in three output flows:

Uniques: lists the records which group score (minimal distance computed in the record) is equal to 1.
Matches: lists the records which group score (minimal distance computed in the record) is higher than the threshold you define in the Confidence threshold field.
Suspects: lists the records which group score (minimal distance computed in the record) is below the threshold you define in the Confidence threshold field.

For another scenario that groups the output records in one single output flow, see Comparing columns and grouping in the output flow duplicate records that have the same functional key.