---
schema_version: "1"
id: c52c3fcef8f3425c936fe24366a358adc4bd4be575db51a9fec1fb59f1e5a834
title: Match Records by Using Advanced Merge
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/os_create_list_action_remove_duplicates_std.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.os_create_list_action_remove_duplicates_std.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 50392f566d07693633aa86aa7f84db1f8160dc7eadb9072a9584bc03f530af01
description: Advanced Merge matches nodes with different names or at different levels in incoming lists. For example, instead of using a primary key that exists in both lists, you can match records based on first and last name.
products:
  - Omnistudio
release: "264"
---
# Match Records by Using Advanced Merge

Advanced Merge matches nodes with different names or at different levels in incoming lists. For example, instead of using a primary key that exists in both lists, you can match records based on first and last name.

To use Advanced Merge, check the **Advanced Merge** box and creat an Advanced Merge Map table. The example table provides the paths and names of fields to match, using groups to indicate which fields to compare.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col>
        <col>
        <col>
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d67129e41">
            <p style="margin-bottom:0;">List Key</p>
          </th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d67129e47">
            <p style="margin-bottom:0;">Matching Path</p>
          </th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d67129e53">
            <p style="margin-bottom:0;">Matching Group</p>
          </th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="List Key" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e41 ">
            <p style="margin-bottom:0;">
              <code>CopyBirthdates:contact</code>
            </p>
          </td>

          <td data-label="Matching Path" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e47 ">
            <p style="margin-bottom:0;">
              <code>firstName</code>
            </p>
          </td>

          <td data-label="Matching Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e53 ">
            <p style="margin-bottom:0;">
              <code>1</code>
            </p>
          </td>

        </tr>
        <tr class="">
          <td data-label="List Key" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e41 ">
            <p style="margin-bottom:0;">
              <code>DRExtractBirthdates:contact</code>
            </p>
          </td>

          <td data-label="Matching Path" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e47 ">
            <p style="margin-bottom:0;">
              <code>firstName</code>
            </p>
          </td>

          <td data-label="Matching Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e53 ">
            <p style="margin-bottom:0;">
              <code>1</code>
            </p>
          </td>

        </tr>
        <tr class="">
          <td data-label="List Key" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e41 ">
            <p style="margin-bottom:0;">
              <code>CopyBirthdates:contact</code>
            </p>
          </td>

          <td data-label="Matching Path" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e47 ">
            <p style="margin-bottom:0;">
              <code>lastName</code>
            </p>
          </td>

          <td data-label="Matching Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e53 ">
            <p style="margin-bottom:0;">
              <code>2</code>
            </p>
          </td>

        </tr>
        <tr class="">
          <td data-label="List Key" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e41 ">
            <p style="margin-bottom:0;">
              <code>DRExtractBirthdates:contact</code>
            </p>
          </td>

          <td data-label="Matching Path" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e47 ">
            <p style="margin-bottom:0;">
              <code>lastName</code>
            </p>
          </td>

          <td data-label="Matching Group" class="slds-cell-wrap" style="vertical-align:top;" headers="d67129e53 ">
            <p style="margin-bottom:0;">
              <code>2</code>
            </p>
          </td>

        </tr>
      </tbody>
    </table>

The two `firstName` fields are compared because they are both in group 1, and the two `lastName` fields are compared because they are both in group 2. For a record to be merged, the `firstName` and `lastName` fields must match.