Skip to Content
author's profile photo Former Member
Former Member

Merge records.

Hi All,

I have a question about merging records. Is their any way can I merge RECORD A into RECORD B. Because I donu2019t want to create new record.

Thanks

John.

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2009 at 01:20 AM

    Hi John,

    Only after record gets into MDM (created) you can merge the records. You need to explain the scenario with little more detail to answer your question correctly

    Regards,

    Arul

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2009 at 04:17 AM

    Hi,

    You can make use of Data Manager's Matching Mode to merge the records. Once records gets merged it will automatically create the new resultant record and delete the existing two.

    In order to work with Matching Mode, you need Rules and Strategies based on which you can decide whether the records are identical and should be merged or not. Say for example RECORD A and RECORD B contains same description which indicates that records are identical then create one rule select Description as the matching field, create one strategy and pass the rule name, now execute this strategy by selecting both the records. If description is identical then you will get the high score and you can merge the records.

    Refer MDM reference guide to know more about Matching Mode

    http://help.sap.com/saphelp_mdm550/helpdata/en/43/e0677c82b40a2ee10000000a11466f/frameset.htm

    Matching Mode

    Regards,

    Jitesh Talreja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2009 at 04:17 AM

    Hi ,

    Yes its possible, assuming these records are present in MDM.

    1. Create rules and strategies based on key fields of your data model, which will help you in identifying duplicates.

    2. Run this strategy by selecting RECORD A and RECORD B and MDM will assign scores to the record.

    3. The higher the score the higher is the chance of record being duplicate.

    4. Mark the check box for Record B and go to Merge record tab of DM.

    5. Select the fields you want in the new record(B) from Record A and B.

    6. Perform the merge action.

    7. You'll see a single merged record now in DM.

    Regards

    Manish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2009 at 02:25 PM

    Hi All,

    I am really sorry if I didnu2019t make it clear.

    Actually my requirement was, while merging two records it will create new record with new auto id. But I need to merge one record to another record that means RECORD A is going to merge with RECORD B then output will be still RECORD B. There will be no new record.

    How could I achieve this?

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2009 at 02:22 PM

    Is their any work around going on for this?

    Can i raise ticket to SAP reg this? Please advise me.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi John,

      This is the default behavior i.e. when you merge two records existing records gets deleted and new record will be added into the repository with new id. You can raise it with SAP and let's see if they can suggest some workaround.

      Regards,

      Jitesh Talreja

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2009 at 04:19 PM

    John,

    We did face this sometime back. What we did was perform merging outside MDM (R/3, CRM etc).

    One record gets marked for archive/deletion, while other gets the updated values based on merging in source system.

    Regards,

    Dev.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi John,

      if you use MDM and have imported all the records into mdm server and you want to do the matching and merging there then there will always be a new record (and of course a new id) created. In your case:

      Merge RECORD A and RECORD B --> the result is RECORD C containing of A and B (e.g. remote key information etc.).

      If you don't want the the id changed then you probably need to introduce a new global_ID that remains the same when merging (only MDM ID changes).

      Hope I could help!

      BR,

      Erdal

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2009 at 05:28 PM

    I think 2 options

    1. Merge records out side MDM and import

    2. While import choose the option to merge if exist ( I'm not very sure abt this)

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.