Specifying Common Attributes - trillium_discovery - trillium_quality - 17.1

The Common Attributes designate the decision routines used to copy data from one attribute into other attributes in the rows linked by a match key.

To specify common attributes

1. From the Navigation or Project View, right-click the Commonizer process and select Edit Process.
2. After you specify match level keys, click Advanced.
3. Select the Common Attributes tab.
4. Select a rule from the drop-down list. Click Add new rule or Delete rule as needed.
   Note: You can specify an unlimited number of rules.
5. Select Test attribute that contains information necessary to commonize data across rows. This setting works in conjunction with the decision routines.
   Note: The sequence number attribute cannot be used in the rules.
6. Select From attribute that contains data which is copied to the target attribute. This is the source attribute.
7. Select Target attribute used to store data copied from the source attribute based on the decision routine.
8. Select Decision routine. The decision routines define the rules for evaluating the test attribute.
9. (Optional) Select No Copy Option as needed. The No Copy Option is available only when the non-blank, non-zero, or non-blank/non-zero option is selected for certain routines. See Non-blank and Non-zero Options for details.
10. Click Back.

    Example:

    Assume that the best row is the one with the most recent date in the Last_contact_date attribute. You want to take the Acct_rep from the record with the most recent Last_contact_date and put this rep into the Common_rep attribute. The settings are as follows:

    Key Attribute (Levels tab)	LEV1_MATCHED
    Test Attribute	Last_contact_date
    From Attribute	Acct_rep
    Target Attribute	Common_rep
    Decision Routine	Highest character

    •  The Highest character routine commonizes the highest value that occurs in the Last_contact_date attribute of all rows at a match level of 1.  
    • It copies the values in the Acct_rep attribute with the most recent Last_contact_date and puts this value into the Common_rep attribute.
    • Row 1 contains the highest value in the Last_contact_date attribute. Therefore the data in Acct_rep in Row 1 is commonized into the Common_rep attribute across a matched set of rows.

    	LEV1_MATCHED	Last_contact_date	Acct_rep	Common_rep
    Row 1	00000013	2005-03-17	JLS	JLS
    Row 2	00000013	2003-01-07	BPL	JLS
    Row 3	00000013	2004-02-08	JCN	JLS