Error in Import to Qualified lookup table

[former_member189669]

A qualified look up table has 1 Non qualifier and 8 qualifiers.Non qualifier values are X and Y.Records were imported from excel sheet to QLT.

In the first trial, for a NQ 'X' all the qualified values of Y have got imported and vice versa .

Now, I need to replace , Value X with Y in non qualifier and retain all Qualifier values. While doing this, a new record is getting appended in the QLT with NQ 'Y'.

How can record appending in QLT be avoided by replacing only Non Qualifier values?

Need very quick help on this please.

Regards,

Vinay M.S

[Former Member · Accepted solution]

Hi Vinay,

Set Qualified Update option as 'replace" and try to import, it may solve your problem.

Cheers,

Veeru.

[former_member189669 · Accepted solution]

Many Thanks. This Worked !

[Former Member]

Hi Vinay,

Set the qualified update to Replace for the non qualifier in the destination fields in Map Fields/

Values pane.

Best Regards,

Silpa Chillakuru