Skipping duplicate IDs in process output
The Extract, Call List, Mail List, and Snapshot processes allow you to specify how to treat duplicate IDs in the process output. The default is to allow duplicate IDs in the output. Follow these steps to exclude records with duplicate IDs from the output.
1.
You see the Advanced Settings window.
a.
Select Skip records with duplicate IDs, and specify the criteria to determine which record to retain if duplicate IDs are returned. For example, select MaxOf and Household_Income to export only the ID with the highest household income.
*
2.
Click OK to close the Advanced Settings window.
Your duplicate ID settings are displayed on the configuration window.
*
In the Mail List or Call List process box, the Skip records with duplicate IDs option pertains only to the fulfillment table created by the process and not to records that are written to contact history. The contact history tables only handle unique IDs. The flowchart designer must ensure that the result set obtains the correct records before reaching the contact history tables. Use the Extract process to de-dupe the result set before the Mail List or Call List process box to ensure that the correct records are written to both the fulfillment table and contact history.