File Activities|FindDuplicateRecords|Modes Of Operation|Advanced Mode

FindDuplicateRecords has three modes of operation, designed to allow you to execute more and more sophisticated, customised data searches.

In Advanced Mode, all facilities are available with no restriction.

Initially, each matching function field will default to '=()' - which indicates that values in different records, for each column must match exactly to be shown as a matching record on the results screen.

You can change the defaults if you need to by selecting a matching function (or a matching function alias) for each column or columns as you wish. Initially, each conversion function field will default to 'NONE()' - which indicates that no conversion will be made before any match is attempted.

You can change the defaults if you need to by selecting a conversion function (or a conversion alias) for each column or columns as you wish.