Skip to main content
Skip table of contents

AO Match Identity Survivor Record

Overview

Advanced Object (AO) Match Identity Survivor Record analyzes the results of two different matching passes—a general one and a more specific one—and deduplicates using the specific Match ID within the general Match ID groups.

For example, suppose you had two match IDs:

  • HH_ID: match ID for household match.

  • IND_ID: match ID for individual match.

This macro would remove duplicates of IND_ID within HH_ID groups. By contrast, a Unique-on-IND_ID operation only deduplicates individuals within each household, so an individual may appear in more than one household. For example, individuals may appear in more than one household if they are students, or have second homes.

In addition to the obvious application to household/individual matching, this macro is useful when you have general/specific match conditions, such as financial trusts containing individuals.

AO Match Identity Survivor Record configuration parameters

AO Match Identity Survivor Record has a single set of configuration parameters.

Input

Parameter

Description

General ID

(Required) The more general match group ID generated by a matching process (for example, Household).

  • Default: blank

Specific ID

(Required) The more specific match group ID generated by a matching process (e.g. Individual).

  • Default: blank

Priority

(Optional) Determines which records should survive within the General/Specific grouping. This is normally assigned using AO Define Source. However, if you have used AO Match Append Info, you should use the Group Order output for this field instead, as it has the ability to process priority tie-breaker logic.

  • Default: blank

Output

Parameter

Description

Survivor flag

(Optional) Will contain "Y" for survivors and "N" for duplicates.

  • Default: SURVIVOR_FLAG

Options

Parameter

Description

Remove non-survivors

If selected, will remove duplicates from the output.

  • Default: no

Configure AO Match Identity Survivor Record

  1. Select the AO Match Identity Survivor Record icon.

  2. Go to the Configuration tab on the Properties pane.

  3. Select General ID and choose the field containing the more general Match ID (for example, Household).

  4. Select Specific ID and choose the field containing the more specific Match ID (for example, Individual).

  5. Select Priority and choose the match rank priority field (typically assigned using an upstream AO Define Source macro). If you used AO Match Append Info, use the Group Order output for this field instead.

  6. Optionally, select Survivor flag and specify the field name for the Boolean survivor output.

  7. Optionally, select Remove non-survivors to remove duplicates from output.

  8. 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.