GetAssociationScores method

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.

Field name.

One of the field names defined in qFieldPairName.

Cardinality of a column/field divided by the number of rows in the table.

If the cardinal ratio is 1, it means that the column is a candidate/primary key.

Number of distinct matches between the two fields defined in qFieldPairName divided by the number of distinct values in the field qFieldName.

If 0, it means that there are no common values between the two fields defined in qFieldPairName.