Survivorship and Commonization - 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 Commonizer allows you to select the best row and copy data across a linked row set after the Relationship Linker process. This process has two functions:

  • Survivorship - Select a user-defined "survivor" row among a group of rows, using survivor selection rules. This function flags a single row at any level, indicating the "best" row of the linked set.
  • Commonization - Copy data in one attribute to other attributes in rows linked by a match key. You can commonize data in an existing attribute or in a new attribute. You can also commonize data sourced from another attribute.

For both functions, you need to specify the Match Key Level first. It specifies the attribute that holds the match key used to group rows for evaluation. For example, rows that were matched together usually have the same LEV1_MATCHED number. Only rows in the same group will be compared and processed.

Note: Input data must be sorted by match keys (such as LEV1_MATCHED) in advance. If you run this process right after the Relationship Linker process, the input is automatically sorted by the match keys. If you run this process separately, be sure to sort the input by match keys. See Sort Utility.

Example

Assume that the best row is determined according to the most recent date in the Last_contact_date attribute. You place an indicator of '1' into the Survivor_flag attribute for the row that has the most recent Last_contact_date. You can commonize the account representative information with the most recent contact date across the set of linked rows, and then identify one account representative per business.

Click any of the following topics to learn more about how to setup and run the Commonizer process.