Creating a Match Candidate Group - trillium_quality - Latest

Trillium Project Rule Analyzer

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Version
Latest
Language
English
Product name
Trillium Quality
Title
Trillium Project Rule Analyzer
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:10:12.949492

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 opens.
  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, to limit the data in the matching window to those records containing the names "John" or "Jane" or that include the last name "Nicholson" enter the following values:

    Value Count

    FIRSTNAME

    LASTNAME

    Value 1

    John

     
    Value 2 Jane  
    Value 3   Nicholson

    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. When you perform a match, only these candidate records will be compared with each other to find matches.