Dedupe Functions

For each of the types of deduplication that are briefly described below, there are the following three options:

1. Deduplication within a file/table: Here, the program looks for duplicate addresses or records within a single file/table.

2. Deduplication between two files/tables: Here, one file/table is compared with another, e.g. in the case of new customer recruitment, to delete existing customers from a promotions list, or alternatively, to take addresses from a black list in consideration during an advertising campaign. The two tables involved in the comparison can have different structures and/or different file formats.

3. Multiple deduplication: Here, several files/tables can be deduplicated at the same time. In doing so, you can determine if a table should be treated as if it were read-only. It would then only be used to search for records in the other tables that appear in both tables. You may also determine if a table should be treated as if it were delete-only. It would then NOT be used to search for records in the other tables. And you can decide whether this table should also be deduplicated (internal matching). Furthermore, with the sequence of the tables, you can determin in which of the two tables the duplicates should be deleted during the deduplication process. Duplicates are always deleted in the table of lower priority. With universal matching, the multiple deduplication function is not available.

The following types of deduplication are available:

• Deduplication Using the Postal Address
• Deduplication Using the Telephone Number
• Deduplication Using the Email Address
• All-in-One Deduplication
• Deduplication Using the Customer No. / Contact Person
• Deduplication Using the Tax Number
• Deduplication Using a Date
• Universal matching