When you specify the decision routines for commonizing or survivor selection, you can optionally select the non-blank (NB), non-zero (NZ), and non-blank/non-zero (NBZ) options for certain routines.
The non-blank, non-zero, and non-blank/non-zero options are used to exclude blank or zero-filled values from comparison of the test attribute. If the options are set, the rows that contain a blank or zero-filled attribute are skipped. If all rows contain either a blank or zero-filled values in the test attribute, then the first row in the match group is selected.
The non-blank, non-zero, and non-blank/non-zero options are available for the following routines:
- Lowest character value
- Highest character value
- Lowest numeric value
- Highest numeric value
- Least occurring value
- Most occurring value
- First value
- See example:
-
Assume that the best row is the one with the most occurring date in the Last_contact_date attribute and you want to use the non-blank/non-zero option. Based on the test attribute values, you copy the Acct_rep from the row with the most occurring Last_contact_date and copy 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 Most occurring non-blank/non-zero value The most occurring value in the Last_contact_date attribute is "0000000000" or blank (both occurred three times), but since the non-blank/non-zero option is specified, the most occurring value is "2004-02-08" in Record 7 and Record 9. Therefore, the Commonizer takes the first value in Acct_rep in Record 7 and it copies into the Common_rep attribute across a matched set of rows.
LEV1_MATCHED Last_contact_date Acct_rep Common_rep Row 1 00000013 0000000000 FFO JCN Row 2 00000013 0000000000 AJK JCN Row 3 00000013 0000000000 BRM JCN Row 4 00000013 BAM JCN Row 5 00000013 JLS JCN Row 6 00000013 BPL JCN Row 7 00000013 2004-02-08 JCN JCN Row 8 00000013 2005-01-18 KJP JCN Row 9 00000013 2004-02-08 FOM JCN
No Copy Option
The No Copy Option is an additional option and available only when the non-blank, non-zero, or non-blank/non-zero option is selected for certain routines. The no copy option is used in conjunction with the non-blank or/and non-zero options to prevent the Commonizer from selecting the first row when all rows contain either a blank or zero-filled values in the test attribute.
The No Copy Option is available for the following routines:
- Lowest character value
- Highest character value
- Lowest numeric value
- Highest numeric value
- Least occurring value
- Most occurring value
- See example:
-
Assume that the best row is the one with the most occurring date in the Last_contact_date attribute and you want to use the non-blank/non-zero and no copy options. Based on the test attribute values, you copy the Acct_rep from the row with the most occurring Last_contact_date and copy 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 Most occurring non-blank/non-zero value, No Copy Option selected The most occurring value in the Last_contact_date attribute is "0000000000" or blank (both occurred three times). If the no copy option is not selected, the Commonizer will take the first row because it cannot find any non-blank/non-zero values. But since the no copy option is selected, the commonization will not be performed and the Common_rep attribute remains blank across a set of rows.
LEV1_MATCHED Last_contact_date Acct_rep Common_rep Row 1 00000013 0000000000 FFO Row 2 00000013 0000000000 AJK Row 3 00000013 0000000000 BRM Row 4 00000013 BAM Row 5 00000013 JLS Row 6 00000013 BPL