Skip to main content

Merging tables

Overview

Merging is the last step in the identity resolution process. The merge step resolves and unifies data by combining duplicate attributes and removing attributes you don't need. In Skypoint MDM, you can merge the matching records to create unique profiles. In this step, profiles identified to have matched either based on the Rule match or the ML match, merge into one table, creating a unique and longitudinal customer profile.

To merge tables

  1. After completing the map and merge steps, navigate to Resolve > Unify.

Alt image

  1. Click the horizontal ellipsis under the Actions column.
  2. Select Edit.
  3. Click Merge.

The Merge window appears.

Alt image

  1. Click Save.
  2. Click Run to start the Merge process.

Alt image

  1. Do one of the following:
ToDo
Run merge the first time or run merge without indexing for the subsequent runSelect Run only merge.
Subsequent run with indexing after profile creation or change in profile attributesSelect Run merge with indexing.

[!Tip] The merge run process supports two flows – Run only merge and Run merge with indexing. The Run merge with indexing will be disabled during the initial merge process as merge and indexing must be done separately. For the first time, the Run only merge will be triggered to merge the table attributes for profile creation. Both Run only merge and Run merge with indexing options will be enabled for the subsequent runs. The Run merge with indexing will trigger merging the attributes as well as applying indexes on attributes that would be mostly used for searching and filtering customer profiles.

Alt image

Once you have completed the Merge process, you will get the following results:

ItemDescription
Combined customer fieldsFields sharing the same semantic type are grouped into a single field.
Individual customer fieldsFields that do not share identifiable semantic types will remain as single fields.
Profile attributesIt displays a complete picture of the profile attributes after the merge stage, for example, name, email, and phone.
Primary keysDisplay the list of primary keys of each table.
Removed from profile recordDisplay those records, which were removed from the merge process primarily due to lack of quality data in the key attributes.
  1. If you want to see the run history of the Merge stage, click Run History. You can view the result either in List (for all) or Group by (for a particular group).

Next step

Once you have completed the merge step, create your profile using the master data. You can use the master data for enrichment, timelines, relationships, and predictions to gain more insight.