I have 2 files.... and I need a list of all the records that...

These are typical questions we get. By defining the input table types differently we can customize the Output table to contain the records we want.

First, Suppression and Intersection input types do NOT contribute to Output tables.

Think of a Suppression table as a list of records which should not get written to the Output and Duplicate tables. Regular, No Purge or Self Purge Input table records which match Suppression records can be written to the Suppressed records Table.

Conversely, an Intersection table is a list of records which DO get written to the Output and Duplicate tables. Records from a Regular, No Purge or Self Purge Input table which do not match any record from an Intersection table can be collected in a Non-Intersected table.

Below are examples of different table types and how they are Output when compared against a suppression or intersection table.

You must register to the forums to see the images below...

Tim61468773 attached the following image(s):