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

ProductProduct description
AProduct AUS
BProduct BIN
CProduct CIN
DProduct DUS
EProduct EUS

Since MDM uses parametric inport, I want to store the distinct values of the COO in a lookup table as shown below.

Lookup table

COO description
USUnited states

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?

Please help.




Hi Vignesh,

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.


Neethu Joy

0 View this answer in context

Helpful Answer