Creating a Match Candidate Group - trillium_quality - Latest

Trillium Director Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Version
Latest
Language
English
Product name
Trillium Quality
Title
Trillium Director Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:24:10.895371

A match candidate group is a set of records in your input data that have something in common. For example, a match candidate group might consist of records containing the same postal code, city, or window key.

When you create a match candidate group you filter the records in your data, creating a subset of records that will be compared with each other in the window match. The original data is still available and is displayed on the Input Data tab; the candidate group will be used to perform the match and is displayed on the Match Candidates tab.

To use a match candidate group

  1. In the Input Data pane, select Use Match Candidates.

  2. Click the Define Filter icon . The Window Matching Row Filter window, shown in the figure below, opens.

    Figure 1. Window Matching Row Filter Window Matching Row Filter
  3. Select whether this will be an ‘and’ or an ‘or’ comparison.

  4. Select data values to be used to filter the data. For example, the filter shown in the figure below would limit the data in the matching window to those records containing the names “John” or “Jane” or that include the last name “Nicholson.”

    Figure 2. Filter Values Entered Filter Values Entered

    If you require a more precise filter, you can add rows by clicking New Row.

  5. Click OK. Records meeting the filter criteria will be displayed on the Match Candidates tab, as shown in the figure below. When you perform a match, only these candidate records will be compared with each other to find matches.

    Figure 3. Match Candidates Match Candidates