Pivot Selection Rule

List of Order By

No

Defines the criterion for selecting a "Pivot record" from a group. Other records are compared to this record in the scope of matchingRulesForARole and/or matchingRulesForMRole, when these rules are used.

Important Columns

List of Column Ref

No

If for any record in the group any of these columns contain empty values or any two records differ in their respective column values, the group is assigned role 'C'.

Columns

List of Column Ref

No

If one of the column values has missing/empty values, it has role 'C'. Moreover, if any two records differ in one of their column values, the group cannot be assigned role 'A'.

Fuzzy Columns

List of Column Ref

No

If any of these columns contain empty values, the group is assigned role 'C'. The difference from the columns property is that records can differ in these columns and still get an 'A' or 'M' role.

Extra Condition For M Role

String

No

This property defines the condition that all records in a given group that must satisfy for the group to belong to role 'M'. If any records don't match this condition, the group gets a 'C' role.

Extra Condition For A Role

String

No

This property defines the condition that all records in a given group must satisfy in order for the group to belong to role 'A'. If any records don't match this condition, the group gets at most an 'M' role.

Matching Rules For M Role

List of Matching Rule

No

Defines the similarity of all records in the group to the pivot record for the group to get at least an 'M' role. If any records don't match this condition, the group gets a 'C' role.

Matching Rules For A Role

List of Matching Rule

No

Defines the similarity of all records in the group to the pivot record for the group to get an 'A' role. If any records don't match this condition, the group gets at most an 'M' role.

When

String

No

Condition for rule use. All records in the group must satisfy this condition for at least one rule (all for the same rule) or else the group gets a 'C' role. The default result is true.