Included fields tab

On the Included fields tab you can define the fields and their weighting in percent that you want to use for the duplicate check.

The duplicate check divides addresses into subsets and then compares each address with all the other in the same subset. The fields included in the addresses of a subset are placed into a character string in the background and then compared with character strings of the other addresses in the other subsets. If a certain match percentage is attained, also known as the threshold value, then the system identifies this as a duplicate. You define the subset fields on the Search options tab.

• Search options tab

For each included field, you can define a weighting in percent in the Factor in % field. The value of the weighting in percent determines when the field is included in the threshold value you already defined.

The value in the Factor in % fields is used to determine the relevance of matches found for specific fields when attempting to find duplicates. A high factor means that the field is highly weighted for the threshold value and is thus taken into greater account than a field with a low factor. The maximum factor is 200%, the minimum factor 20%.

• Click New to include a new field in the set of fields to be compared.
• Click Change to change the weighting for an included field.
• Click Delete to remove a field from the set of fields to check.
• Click Default values to reset the field weighting back to the default values.

If you have added additional fields to the default group of fields that are checked and then clicked Default values. ,then the fields you added will be removed again and no longer included in the duplicate check.

Use cases for: Factor in %

• If you have included a field which can have very different values, then you should define a higher factor. For example, the Name field can contain very different values and should therefore be given a high weighting so that it is included in the threshold value, this allows you to perform a much stricter duplicate check.
• If you have a lot of individual contacts or contact persons in your address data stock, then you should define a lower factor for the Company field. This helps you to avoid duplicates being flagged from different addresses with similar company names.