Manual Post-Editing

By means of the manual post-editing, the results of a function can be verified and if need be, corrected by the user. In the case of match functions, the addresses which are recognised as being duplicates are presented in the form of doublet groups. Beside the data which is relevant for the comparison, the contents of all other columns of the table that are not involved in the comparison are also presented. Based on this information, the user can then decide which of the addresses that were recognised as duplicates should really be deleted.

 

Deletion Log

With the match functions, the deletion log is the printable version of the matching results and duplicate records. Two different forms of the deletion log are available, the first being relatively short and compact, and the other form being significantly longer but therefore easier to read. In both forms, the output can be saved as different file types: besides PDF, you may also select HTML, Text, CSV, MHT, EXCEL, RichText (rtf) and graphics. Furthermore, the output can also be sent in the above-mentioned file formats as an attachment per email or can be printed.

 

Results Log

With the match functions, the results log is basically the printable form of the matching results. The options to print, save and send as an email are similar to those of the deletion log.

 

Deleting in the Source File

With all functions that are capable of deleting records, the results of the function can also be applied directly to the source file. In the case of match functions, the records that are recognised as being duplicates are then deleted out of the source file.

 

Results File

All the records from the source file are saved in the results file according to the results of the function. In the case of matching results, this includes all records with all columns which were NOT deleted in the source table. With functions that enhance the source file with additional information or change the contents of data fields, the results file includes all records with all columns of the source table and also the additional information or altered data fields. The format of the results file can be selected in the process, either as a CSV, XLS or XLSX-file.

 

Archive File

All records with all columns from the source file that would be deleted by the application of the results of a function are saved in the archive file. In the process, one can select whether the archive file should be saved as a CSV, XLS or XLSX file. If a results file is also generated, then the results and the archive file contain together all the records from the source file.

 

Doublets File

In the doublets file with the match functions, the results are saved in a separate file. In the process, one can select whether the doublets file should be saved as a CSV, XLS or XLSX file. Based on this file, more advanced queries can be configured, for e.g. in order to delete or transfer contact persons in a second table. The data can thereby be stored in two different forms. One option is a form where only the doublets and address number of a single record is written in each row. In the other form, both the address number of the record to be deleted and that of the record to be maintained are saved in the row beside the doublet number.

 

Flagging in the Source File

With the match functions, the records that are recognised as being duplicates can also be flagged directly in the source file, namely either with the doublet number or also with a simple deletion flag. Also here, this information can then be used to configure more advanced queries.

 

Deleting Using a Stored Procedure

Finally, with the match functions, the results can also be processed further using a special stored procedure in the database. Of course, this is only possible with database servers. Also here, this option can then be used to add further actions to the deletion process, such as for e.g. a secondary deletion procedure or the transfer of information from the address which is to be deleted to the address which is to be maintained.

 

Enhancement in the Source File

With the matching functions where a comparison is made between two tables/files, the results of the comparison can also be used to transfer information from one table into another. The user can determine which data fields can be used for this purpose. For example, the data field that contains the telephone number can be entered as a source data field, and in the other table, a previously empty data field is designated as target data field, where the contents of the target data field can also be overwritten with data from the source table if necessary. If the target table is an Excel file, then either an existing target data field can be entered, or a new data field that is to still be created by the program. With all other data formats, the target data field has to already exist in the table. In other words, the results of the comparison establish a relationship between the individual records of both tables, which are then used to supplement information in certain data fields from one table into the other. With the comparison between two tables/files, the information from the records that are flagged as not to be deleted is transferred to the records that are flagged for deletion.

By contrast, with the comparison within one table/file, the corresponding function transfers the contents of one or more data fields from the record of a doublet group that is flagged for deletion to the record(s) in the same doublet group that are not flagged for deletion. This can be used to complete the records that are to be kept with the data from the records that are flagged for deletion.

 

Enhanced Results File

„Enhanced Results File“ also functions quite similarly to „Enhancement in the Source File“. However, the results are not rewritten to the source file; rather they are written to a new file. In doing so, with the comparison within one table/file, just like with the results file from the deletion functions, only the records that are not flagged for deletion are written, supplemented with the information from the records flagged for deletion that were selected for enhancement. By contrast, with the comparison between two tables/files, all records from the target table are written in the results file, irrespective of whether they are flagged for deletion or not, since precisely the information from the records that are not flagged for deletion in the second table are transferred to the records that are flagged for deletion in the first table.