The Results Screen|Merging Duplicate Records

Merging Duplicate Records

When the merging option is selected, the final record in each matching group is the merged or consolidated record.


This record is made up of what are felt to be the best data values in each column derived from the other records in the matching group, according to the merge rules used.


However, you can override the default merged value in any column by selecting the cell it is in and right clicking to bring up a menu of choices to use to populate the merged column value.


When preparing and saving merges, the following occurs.



A number of functions are available which determine which of the available values are offered by default for the columns in the merged record.

They are as follows :-