on 04-28-2008 11:19 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi sireesha,
your Question is much confusion could you please explain briefly.
Regards,
Ashok.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.