Deduplication in One File / Table

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

In order to deduplicate records within one table, the following steps are required:

  1. Selection of the matching criteria: deduplication can be based on the postal address, the telephone number or the email address.

  2. Opening the Excel file to be processed: When a spreadsheet other than the first one should be used in the corresponding Excel file, it can still be selected at a later time on the page where the field assignment is also carried out.

  3. Carrying out the field assignment: You can find more information about this in the documentation.

  4. Determination of the deduplication parameters: When the postal address is selected as a criterion, then the component parts of the address that should be used in the comparison and the threshold for the degree of matching can be entered here.

  5. When the deduplication is finished, the matching results will be presented in form of a table. In this form, it can be verified before it is further processed. If required, manual modifications can be made here.

  6. Finally, the matching results can then be processed, for example, in that the duplicate addresses are deleted in the source table.

 

Deduplication in One File / Table