The Matching tool is used for finding matching records in one or two data sources. When one data source is used, matching records are identified within the source. This is primarily for data cleansing purposes, for removing duplicate contacts from a master table for example. When two data sources are used, matching records that intersect two sources of data are identified. For example, identifying contacts to be suppressed from a mailing, for updating contacts' details, or for merging new contacts into a master table. Matching records are not identified within each table, but they can be removed beforehand if necessary (for example, when merging new contacts from an update table into a master table, duplicate contacts can first be removed from the update table, then the cleaned update table overlapped with the master table; these two steps would need to be done separately, using either a single matchIT Hub engine or two chained engines).
Matching takes one or two inputs (Main input & Overlap input). Connect up to two input steps by dragging Input tools onto the canvas. Left click on each input tool’s connector and drag onto one the Matching tool’s input connectors.
Matching has four different output connectors, these are:
|MP||Matching Pairs, or Grouped Matching Pairs|
|MG||Grouped Matching Pairs, or all input records with matches flagged|
|DE||Unique (deduplicated) Data|
Connect downstream tools to at least one of these.