AO Match Report | Redpointdocs

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. Default: blank
Match ID	(Required) Match group ID generated by upstream matching process. Assumes that empty (null) values are unique. Default: blank

Parameter

Description

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

Parameter	Description
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.
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.