Skip to Content

Delete duplicate entries from a record in MDM.

Hi ,

I have a Main table Product Information, in which i have a look up Qualified Vendor Information table.

Vendor information table has fileds liken Vendor Name , Vendor ID, country and other pricing details.

Due to some upload bug in data manager we have two entries in Vendor information for one record, the only difference is one has country and the other item has value as <NULL>. So thats a duplicate Item for one single product.

I want to find out an easy way on how to delete the vendor with Country as <NULL>.

I didt try some mapping techniques via Import manager, but it simple deleted the whole record and not Just the vendor entry.

Request your pointers on the same.

Br,

Bhanu.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2012 at 04:21 AM

    HI Nanduri,

    In your case you have two qualified links for same product info and one of the link is duplicate(undesired) qualified link with Country field as None.

    So in order to correct your data you need to have only correct data in some Excel/XML file. Excel File would be easier to use.

    In Data Manager, you need to enter filter criteria to search only valid qualified links.

    Using Free Form Search:

    First use some filter criteria to select all those records which have duplicate qualified links.

    Then in Free Form Search: Vendor Information Table, field 'Country', set Operator "Is Null" and select value as "No".


    This will display only those qualified links which are valid and does not have NULL value for Country field.

    Then using File --> Export --> Excel, export all these records to your desktop.(You need to click on the Qualified checkbox while exporting the records and select all qualified fields to be exported. Also you can select only few main table fields which would be required for matching criteria in Import Manager)

    In this way you will get all the data you need to upload once again.

    Now open Import Manager and connect to this file. Then select appropriate Destination table(main table) and map the values to appropriate fields. Now select the Qualified Link field and set property "Set Qualified Update" to "Replace" in tab Map Fields/Values. After you have done all the mappings, and set matching criteria in Match Records tab, then you can import it and only correct data would be restored in data manager and unwanted duplicate links would get deleted.

    Kindly check this and let me know your results/concerns.

    Thanks and Regards,

    Ankush Bhardwaj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2012 at 02:36 PM

    Hi Bhanu,

    Due to some upload bug in data manager we have two entries in Vendor information for one record

    Do you mean to say that you have duplicates in your Qualified table?

    If so, try uploading the data in your qualified table with the set qualified update option as replace(You will get this option when you right click on the Qualified field in the Destination fields grid)?

    Hope this helps

    Rgds,

    Prasad

    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.