Duplicate Values

When worksheet data are rebuilt into data arrays, GS+ checks each record against every other record to check that no duplicate coordinates are present. If one or more records are found to be duplicates, a warning screen will appear with a request for action:

$images\duplicate_query.gif$

Use first value (make other values missing)

This option includes the first record encountered (record 1 in the case described) in the analysis and marks other duplicates in the worksheet (records 8, 25, and 26) as temporarily missing values. So long as these values remain marked as missing, on subsequent worksheet rebuilds this Duplicate Query warning will not occur.

Use last value (make other values missing)

This option is the same as the first option above except that the last record encountered is used in the analysis (record 26 in the case described) rather than the first.

Use average value (make none missing)

This option directs GS+ to use the average of the duplicate records. It does not mark any values in the worksheet missing, which means that the next time the worksheet is rebuilt this Duplicate Query warning will occur again.

Stop data build and examine worksheet

Specifying this option will cause the data build to halt and will display the first duplicate record of the data worksheet. Any other duplicates already found during the data build will be reset to non-missing, i.e. the worksheet will be returned to its pre-build state.

Also take this action for other duplicates of this build

Checking this box causes other duplicates encountered to be treated the same as this set of duplicates. For data sets with many duplicate values, this option saves time by keeping this dialog window from displaying again during the present build. Regardless of whether it is checked, this dialog window will reappear if duplicates are found during a subsequent build.

Cancel

Cancel the data build. Any duplicates set to missing values during this build will be reset to non-missing.

OK

Accept the option specified and continue the data build. The data build restarts every time a duplicate is encountered to provide a comprehensive scan; thus if GS+ is instructed to “Also take this action for other duplicates of this build” you will see the progress bar at the bottom of the screen reset to zero every time a duplicate is encountered.