Skip to main content
Skip table of contents

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

  1. Select the AO Match Report icon, and then select the Configuration tab on the Properties pane.

  2. Select Source and select the source name, typically assigned using an upstream AO Define Source macro.

  3. Select Match ID and select the field containing the match ID generated by the upstream matching process.

  4. Optionally, select the Counts fields and specify different output field names.

  5. Optionally, go to the Execution tab, and then set Web service options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.