Sample Reference Matching - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

The following table shows the contents of the input entity before the Reference Matching occurs. Note that the reference match key attribute, reference_level1_key, is blank.

Row

Name

Address

Post code

Reference_level1_key

Window_key_01

1

John Smith

5 Main St.

01876

 

018MNSM

2

John T. Smith

5 Mane St.

01876

 

018MNSM

3

Jan Jones

5 Main St.

01876

 

018MNJO

4

Jane Jones

5 Main St.

01876

 

018MNJO

5

Robert White

16 Linnell Circle

01543

 

015LNWH

The following table shows the contents of the reference entity before the Reference Matching occurs.

Row

Name

Address

Post code

Reference_level1_key

Window_key_01

1

John Smith

5 Main St.

01876

0000000001

018MNSM

2

Jane Jones

5 Main St.

01876

0000000002

018MNJO

Note: Every row in the reference entity must have a unique match key.

The results of the Reference Matching are as follows:

  • Each input row is compared to reference rows when rows contain the same window key.
  • Rows 1 and 2 in the input entity match Row 1 in the reference entity. The match key (0000000001) is copied to the input entity.
  • Rows 3 and 4 in the input entity match Row 2 in the reference entity. The match key (0000000002) is copied to the input entity.
  • Row 5 in the input entity has no match in the reference entity. A new key is created for this row, based on the Key Generation settings.

Based on the above results, the output is now populated.

Row

Name

Address

Post code

Reference_level1_key

Window_key_01

1

John Smith

5 Main St.

01876

0000000001

018MNSM

2

John T. Smith

5 Mane St.

01876

0000000001

018MNSM

3

Jan Jones

5 Main St.

01876

0000000002

018MNJO

4

Jane Jones

5 Main St.

01876

0000000002

018MNJO

5

Robert White

16 Linnell Circle

01543

9999900001

015LNWH

The reference_level1_key attribute is now populated with reference_level1_key values from the reference entity. Because Row 5 had no matched row in the reference entity, a new key was created for Row 5 based on the Key Generation settings: Cycle number + Start value

After all records are passed through the reference matching process, normal relationship linking begins on the input records. This process attempts to match all records within a window to all other records within the same window.

Click any of the following topics to learn about how to set up and run the Reference Matcher process.