cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Value map.

Former Member
0 Kudos

Hi Guys

We have a flat lookup table of Registration types. This is linked to a qualified lookup table called Registrations through a field Reg Type. (DF=Yes, Qualifier= No). This Qualified lookup table is then linked to the Main Table through the Field Reg. Id.

On import when I try to map the Reg id on the main table we expect to see a list of values, Registration types, from the flat table lookup , so we can value map. But instead we get a list of values as follows [NULL REG TYPE].

Is there something we are missing here? What is this being displayed instead of the lookup values?

NB: the lookup values are already loaded.

All help greatly appreciated.

Rgs

C

Accepted Solutions (1)

Accepted Solutions (1)

michael_theis
Active Contributor
0 Kudos

Hi Con,

if you use a flat lookup field a non-qualifier display field in a qualified look up table, you have to create the corresponding non-qualifier qualified look up table records first to be able to automap.

Start the data manager. Choose your qualified look up table. This one should be empty. Create some new non-qualifier records, you should be able to use now your flat look up for selection. If you now have a look at the Import Manager again, you'll see the list of newly created non-qualifiers for value mapping.

Just a hint: if you do not need the flat look up somewhere else in your data model, you can use the non-qualifier field as a look up as well!

Kind regards

Michael

Former Member
0 Kudos

Hey Michael

Thank you for the answer ( and the hint)

Rgs

Con

Answers (0)