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
- From the Navigation or Project View, right-click the Commonizer process and select Edit Process.
- After you specify match level keys, click Advanced.
- Select the Common Attributes tab.
-
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.
-
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.
- Select From attribute that contains data which is copied to the target attribute. This is the source attribute.
- Select Target attribute used to store data copied from the source attribute based on the decision routine.
- Select Decision routine. The decision routines define the rules for evaluating the test attribute.
- (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.
-
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