Search Results for

    Show / Hide Table of Contents

    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:
    To Do
    Run merge the first time or run merge without indexing for the subsequent run Select Run only merge.
    Subsequent run with indexing after profile creation or change in profile attributes Select 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:

    Item Description
    Combined customer fields Fields sharing the same semantic type are grouped into a single field.
    Individual customer fields Fields that do not share identifiable semantic types will remain as single fields.
    Profile attributes It displays a complete picture of the profile attributes after the merge stage, for example, name, email, and phone.
    Primary keys Display the list of primary keys of each table.
    Removed from profile record Display 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.

    • Improve this Doc
    In This Article
    Back to top © SkyPoint Cloud Inc. All rights reserved.