Check for Duplicate Data

About this task

To check for duplicate data:

In the Standard Rule tab, verify that Update is selected as the standard rule and that Transaction Register is selected for the table and key to use.
Select the internal storage field (Field1 through Field 6) for which you want to assign the contents of the current field.
Note: You do not need to assign values to the storage fields in order (that is, assigning a value to Field1 first, then Field2, and so forth), and you can assign multiple fields to the same internal storage field (for example, the values of NAME, ADDRESS, and CITY may all be assigned to Field1). However only the last field for which the Update standard rule is executed will be stored.

For more information about the size limitations of Field1 through Field6, see Field Size Limits.
Click OK to add the standard rule.
Repeat steps 1 through 3 to add as many Update standard rules as necessary.
Following the sequence of Update standard rules, select a map component and choose Select as the standard rule.
Select Transaction Register is selected for the table and key to use.
Note: If the translator finds that the map component (for which the Update standard rule is in operation) contains data that is the same as that for which the matching Select standard rule is operating, it adds an error to the translator report noting the duplicate data.
Click OK to add the standard rule.