AO Match Group Differences
Advanced Object (AO) Match Group Differences accepts as input two sets of Match ID produced by different matching processes and outputs either the differences or similarities between their match groups. It is especially useful for tuning matching processes and identifying multiple-person households. Essentially, you are comparing the group counts from two different match processes, and flagging the records belonging to groups whose count has changed.
AO Match Group Differences produces the same record schema on output as on input, but with some records removed.
To see an example of this Advanced Object in action, open the AO Matching/Samples folder, and then open the Consumer Matching Sample Hierarchical project.
AO Match Group Differences configuration parameters
AO Match Group Differences has a single set of configuration parameters:
Match ID 1 | Required. Match group ID from the matching process with the looser match thresholds. Default: Blank. |
Match count 1 | Required. Match count field assigned using AO Match Append Info. Contains the number of records in each record's match group. Unique records have a count of 1. Default: Blank. |
Match ID 2 | Required. Match group ID from the matching process with the tighter match thresholds. Default: Blank. |
Match count 2 | Required. Match count field assigned using AO Match Append Info. Contains the number of records in each record's match group. Unique records have a count of 1. Default: Blank. |
Flag match group | Specifies whether differences or similarities between match groups in the two inputs are identified. Default: Differences. |
Sort output | If selected, sorts the output by ID 1, then ID 2. Default: No. |
Configure AO Match Group Differences
Select the AO Match Group Differences icon, and then go to the Configuration tab on the Properties pane.
Select Match ID 1 and select the field containing the Match ID from the matching process with looser match thresholds.
Select Match count 1 and select the field containing the Match count field assigned by the upstream matching process with looser match thresholds.
Select Match ID 2 and select the field containing the Match ID from the matching process with tighter match thresholds.
Select Match count 2 and select the field containing the Match count field assigned by the upstream matching process with tighter match thresholds.
Select Flag match group and specify whether to identify Differences or similarities (Same) between match groups.
Optionally, select Sort output to sort the output by Match ID 1 and then by Match ID 2.
Optionally, go to the Execution tab, and then set Web service options.