AO Match Report
Overview
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 following 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
Parameter | Description |
---|---|
Source | (Required) Data source name, typically assigned using AO Define Source.
|
Match ID | (Required) Match group ID generated by upstream matching process. Assumes that empty (null) values are unique.
|
Counts
Parameter | Description |
---|---|
Uniques | Total number of records matching no other record.
|
Masters | Total number of records that are the first record in any group of matched records.
|
Single-source masters | Total number of records matching only within a single source (single source masters).
|
Multi-source masters | Total number of records that are the first record of a group matching more than one source (multi-source masters.
|
Duplicates | Total number of presumed duplicates (records 2 through N) of any group of matched records.
|
Single-source dupes | Total number of presumed duplicates (records 2 through N) of groups matching only within a single source (single duplicates).
|
Multi-source dupes | Total number of presumed duplicates (records 2 through N) of groups matching more than one source (multi-source duplicates).
|
Configure AO Match Report
Select the AO Match Report icon.
Go to the Configuration tab on the Properties pane.
Select Source and choose the source name, typically assigned using an upstream AO Define Source macro.
Select Match ID and choose 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.