3 Replies Latest reply: May 11, 2012 9:11 AM by Neethu joy RSS

Upload data into main table consisting of a lookup field

Vignesh Perumal
Currently Being Moderated

Hi,

 

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
COO
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
COO description
USUnited states
INIndia

 

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.

 

Thanks,

Vignesh

Actions