Skipping duplicate IDs in process output

The Extract, Call List, Mail List, and Snapshot processes allow you to specify how you want to treat duplicate IDs in the process output. The default is to allow duplicate IDs in the output. Follow these steps specify that duplicate IDs are excluded from the output.

1.	From the configuration window of the process, click More.

You see the Advanced Settings window.

To specify that any records with duplicate IDs are skipped, select the Skip Records with Duplicate IDs checkbox, and choose the criteria that Campaign will use to decide which record to retain if duplicate IDs are returned. For example, you can select MaxOf and Household_Income to specify that when duplicate IDs are returned, Campaign exports only the ID with the highest household income.

This option only removes duplicates within the same input field. Your data can still contain duplicate IDs if the same ID appears in multiple fields. If you want to remove all duplicate IDs, you must use a Merge or Segment process upstream of the Extract process to purge duplicate IDs or create mutually-exclusive segments.

2.	Click OK to close the Advanced Settings window.

Your duplicate ID settings are displayed on the configuration window.