Skip to Content
avatar image
Former Member

Mapping supplier ID of the source file to the supplier ID of the subtable

Dear Experts,

I am new to MDM. I have one immediate task to be completed in MDM in my project. I have an excel file while contains the business data in which supplier ID is one of the fields in that.

My requirement is to import this data into MDM import manager. But the issue in importing the data is i cannt map the supplier ID of the source file to the supplier ID of the subtable Suppliers while importing the source file data. As there is no field mappling with Supplier ID in the main table to the source file obviously i need to map only to the subtable of the supplier ID field.

I have tried by importing the data into subtable first before importing it in the import manager and then while importing in the import manager i have tried to map supplier Id of the source file to the Supplier ID of the main table. But mapping could not be done tough there is data in the subtable.

Can anyone tell me how should i map supplier id of the source file to the supplier id of the subtable while importing data into import manager?

Please help me out.

Thanks & Regards

Sireesha.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Apr 28, 2008 at 10:36 AM

    Hi sireesha,

    If I have understood your requirement correctly, then you want to Populate data from the Source - Supplier ID to one of the field Supplier ID in a subtable -.

    Please perform the following task:

    1.Open Import Manager.

    2. Connect to the Source.

    3. Choose the Source and the Destination Tables in Import Manager.

    Source and the Subtable ( in theDestination)

    4. Go to the Map Field/Value Tab

    5. Map the 2 fields

    6. Select the Matching Field

    7. Import the Data

    The Data will be imported into the Supplier Field of the Subtable.

    Please correct me if this is not the case

    Hope it helps.

    Thanks and regards

    Nitin jain

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2008 at 10:50 AM

    Hi Sireesha,

    Yes you are correct to say that you need to import data to sub table first. Follow the steps given by Nitin. Also, to add, since you have already imported records, have you done value mapping as well?

    As if we have values already, we need to perform value mapping. When you click on field supplier id, and look down in value mapping table, do you find all green buttons or no buttons... if none, pleae map or add the values as well....

    Hope this helps!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2008 at 11:14 AM

    Hi sireesha,

    your Question is much confusion could you please explain briefly.

    Regards,

    Ashok.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2008 at 11:19 AM

    Hi sireesha

    Its confusing........Could you please explain clearly......

    you want to map Source Main table with Source Sub Table ?

    I could not understand

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 28, 2008 at 12:10 PM

    hi Siree,

    Sorry to say but yes your question is some what confusing as Ashok was pointing. But as my understanding of your question goes...

    I you dont have any supplier ID in main table and want to import it to sub table while import data into main table; then make your supplier id in your sub table as display field then might be your problem will be solved.

    Cherrs,

    Cherry.

    Add comment
    10|10000 characters needed characters exceeded