AO Match Report
The Advanced Object (AO) Match Report macro takes a single stream as input and produces a single output categorizing all matches and giving counts by type of match. The input table must have both Source and Match ID predefined. This macro identifies single-source and multi-source matches based on the source. Data output is of the form:
UNIQUE_CNT | MASTER_CNT | SSM | MSM | DUPE_CNT | SSD | MSD |
---|---|---|---|---|---|---|
889 | 2507 | 168 | 2339 | 6604 | 204 | 6400 |
AO Match Report configuration parameters
AO Match Report has a single set of configuration parameters:
Input
Source | Required. Data source name, typically assigned using AO Define Source. Default: Blank |
Match ID | Required. Match group ID generated by upstream matching process. Assumes that empty (null) values are unique. Default: Blank. |
Counts
Uniques | Total number of records matching no other record. Default: UNIQUE_CNT. |
Masters | Total number of records that are the first record in any group of matched records. Default: MASTER_CNT. |
Single-source masters | Total number of records matching only within a single source (single source masters). Default: SSM. |
Multi-source masters | Total number of records that are the first record of a group matching more than one source (multi-source masters. Default: MSM. |
Duplicates | Total number of presumed duplicates (records 2 through N) of any group of matched records. Default: DUPE_CNT. |
Single-source dupes | Total number of presumed duplicates (records 2 through N) of groups matching only within a single source (single duplicates). Default: SSD. |
Multi-source dupes | Total number of presumed duplicates (records 2 through N) of groups matching more than one source (multi-source duplicates). Default: MSD. |
Configure AO Match Report
Select the AO Match Report icon, and then select the Configuration tab on the Properties pane.
Select Source and select the source name, typically assigned using an upstream AO Define Source macro.
Select Match ID and select the field containing the match ID generated by the upstream matching process.
Optionally, select the Counts fields and specify different output field names.
Optionally, go to the Execution tab, and then set Web service options.