How to import data usin Import manager if one of the field is of type LOOKUP[FLAT].

[Former Member]

Consider a scenario:

Where I created a Main table named STUDENT and it has 4 fields,

a) Among which 2 fields are OF DATA TYPE TEXT[50] and

b) Remaining two are of DATA TYPE LOOKUP[FLAT] and corresponding look up table also created in the repository.

When I tried to create a file with certain input records and tried to import the values into the Main table using MDM IMPORT Manager, I am getting error at the IMPORT STATUS tab with the action item message: MAP 'FILED NAME OF LOOKUP[FLAT] TABLE' FIELD VALUE(S).

Do I need to do any special action to import record if the field is of data type LOOKUP[FLAT].

Please advice.

[Former Member · Accepted solution]

Hi,

Since you need to import value into a field which is referred by a flat look table, you need to map the values of that field to the values maintain in flat look up table.

You can do the mapping from "Map Fields/Values" Tab.

You have probably Mapped Source fields with destination fields, but in case of importing values in lookup fields you need to map Source Value with destination value.

Keep the cursor on the required lookup field in Source field section, below that section you will be able to see Source Value section perform the mapping in that section too and it will resolve your issue.

Regards,

[Former Member · Accepted solution]

Hi Ankit,

Thanks for your time. It helped me a lot.

Regards.

[Former Member · Accepted solution]

Cheeers !!!