Deduplication in One File
In order to deduplicate records within one table, the following steps are required:
-
Selection of the matching criteria: deduplication can be based on the postal address, the telephone number or the email address.
-
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.
-
Carrying out the field assignment: You can find more information about this in the documentation.
-
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.
-
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.
-
Finally, the matching results can then be processed, for example, in that the duplicate addresses are deleted in the source file.
