Upload data into main table consisting of a lookup field
I am new to MDM and i am struggling with how to proceed with the below scenario
I have a main product table(Shown below) with COO as a lookup field.I want to import this import this information into the repository.
Given product table with data to be imported
Since MDM uses parametric inport, I want to store the distinct values of the COO in a lookup table as shown below.
When performing data import using the import manager, I first have to fill the lookup table.
Then I have to import the values in the main table ?
If this is the case, how can I link the COO already stored in the look up tables to the products in the main table?
Neethu joy replied
In MDM you must be having main table with fields:
Product which is text
Product Description ( Text)
COO (Lookup Field referncing to Lookup Table )
Now First process you have to load lookup table for that:
Connect the file for lookup table to Import Manager(IM).
In Source select the file and in Destination select Lookup Table.
Go to Field maaping map the fields and Import.
Now to Load Main table product data.
Connect the file with product info with IM.
In source select the file.In Desctination select main table.
Go to field mapping .In destination you will find fields Product,Product Description and COO
Map the source fields to Main table
when you map source field COO to main table field COO which is lookup field ,you will get values enabled in Value Conversion and mapping pane.
Map the values also.
and then import.