AssociationScore

Pair of fields.

<FieldName1> / <FieldName2>

Where:

<FieldName1> is a field in the table 1 (defined in qTable1)

<FieldName2> is a field in the table 2 (defined in qTable2)

If the field is a synthetic key, the name of the field is preceded by [Synthetic key]:.

Flag used to interpret calculated scores.

One of the following values or sum of values that apply:

• 0: The cardinal ratio cannot be zero but the symbol score and the row score can be zero.
• -1: The fields do not have the same type.
• -2: The number of rows of the field FieldName1 is zero.
• -4: The number of distinct values of the field FieldName1 is zero.
• -8: The number of rows of the field FieldName2 is zero.
• -16: The number of distinct values of the field FieldName2 is zero.

Example:

The number of rows of the field FieldName1 is zero, and the number of distinct values of the field FieldName2 is zero, then qScoreSummary is -18.