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.
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.
- Schema Editor
- Input and Output Settings
- Specifying Match Key Level
- Designating Survivor Records
- Specifying Common Attributes
- Running the Commonizer