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

[Former Member]

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.

[former_member201266]

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.

[Former Member]

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

[Former Member]

Hi sireesha,

your Question is much confusion could you please explain briefly.

Regards,

Ashok.

[Former Member]

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!

[Former Member]

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

[Former Member]

Hi All,

I am sorry to confuse u all guys...

I got it solved by myself.

Regards

Sireesha.