Relationship Linker 2 - E-mail - trillium_discovery - trillium_quality - 17.1

Trillium Beyond The Basics Guide

Trillium > Trillium Discovery
Trillium > Trillium Quality
Product family
Product name
Trillium Quality and Discovery
Trillium Beyond The Basics Guide
Topic type
How Do I
First publish date

The purpose of the second Relationship Linker process is to identify rows that match on Window Key 02 and to create a Link file.The Link file connects the matches identified by the first Relationship Linker to the matches identified by the second Relationship Linker.

Note: Generating a Link file in the Relationship Linker process is a requirement for multi-matching projects. You can find detailed information in the TSS Help about the Link file (Develop > Data Linkers > Using a Link File).

Setting up the second Relationship Linker involves steps that were not part of the first Relationship Linker process. Specifically, you must:

  • Establish settings for the Link file.

  • Tune the Relationship Linker to include the e-mail attribute.

These steps are described, along with the other required steps, in the following procedure.

To set up and run the second Relationship Linker process

  1. In the project view, right-click the output of the second Sort for Linking process.

  2. Click Add process branch. The Create Process window opens.

  3. Select Relationship Linker from the Process selection list, select the Configure Now check box and click OK.

  4. Click the Process tab and specify the following settings:

    • Attribute containing record type: PR_NAME_FORM_01 (the default)

    • Attribute contained window key: WINDOW_KEY_02

    • Override record type: Consumer only

    We are targeting consumer records where all the potential matches can be found.

  5. While still in the Process Settings edit window, click Advanced. The Linking window opens.

  6. Establish the following settings:

    • Type of match to write to Link file: Passes only

    • Attribute to write to Link file: LEV1_MATCHED

    Establishing these settings is what signals the Relationship Linker to create the Link file.

  7. Click the Match Rules tab and select the Consumer level 1 rules required? check box. Clear the other boxes.

  8. Click Back.

  9. Click the Tools tab and then click Launch Rules Editor. The Relationship Linker Rules Editor opens, showing the default rules that apply to name and address data in your records.

  10. In the Field List Editor, add an entry for e-mail at the beginning of the list and add entries for business name and surname at the end of the list, using the following values:


    • Description: email

    • Score A: 100

    • Score B: 0

    • Comparison Routine: partial1

    • Field Name: Email

    Business Name

    • Description: busname

    • Score A: 90

    • Comparison Routine: busname

    • Field Name: PR_BUSNAME_RECODED_01


    • Description: surname

    • Score A: 94

    • Comparison Routine: spelling

    • Field Name: PR_SURNAME1_RECODED_01

    When you are through, the Field List Editor should look like the one shown in the figure below.
    Figure 1. Field List Editor (Second Relationship Linker)

  11. Change focus to the Grade Pattern Editor window.

  12. Create new patterns for the fields as follows:


    • Category: F

    • Pattern: 099

    • Grade: B

    Business Name

    • Category: P

    • Pattern: 201

    • Grade: A


    • Category: P

    • Pattern: 301

    • Grade: A

    Note: Patterns P201 and P301 are inserted before the first suspect pattern. This tells the Relationship Linker that if the e-mail is the same, check to see if the address, business name or surname is the same before going to the suspect matches.
    The resulting Grade Pattern Editor window looks like the one shown in the figure below.
    Figure 2. Grade Pattern Editor (Second Relationship Linker)

  13. Select File > Save and then close the Relationship Linker Rules Editor.

    Note: Select OK to delete duplicate patterns when you save the files.
  14. Click Finish to save the changes you made to the Relationship Linker.

  15. Run the second Relationship Linker process and review the two output files. The Link file for the sample project is shown in the figure below.

This shows that the row with the LEV1_MATCHED 00000023 from the first Relationship Linker links to the row with the LEV1_MATCHED 000000024 in the second Relationship Linker, with the pattern P102. Likewise, the rows with the LEV1_MATCHED 000000004 in the first Relationship Linker link to the rows with the LEV1_MATCHED 00000025 in the second Relationship Linker, with the pattern P301, and so on.
Figure 3. Link File (Second Relationship Linker)