Applymap function issue

[Tatynout]

Hi,

i have an issue with the applymap function. 

My mapping table looks like this:

and the table in which i am applying the Applymap() function looks like this:

In my mapping table, i have the Product ID TA09 twice one with a space at the beggining and another one without a space. The isue i have now is that when i am trying to retrieve the product name from my mapping table with that specific code, it maps the product ID with the space eventhough the Product ID found in my table is without space.

Is there please an explanation to that?

Thanks for you reply. 

Tatiana

[Frank_Hartmann · Accepted solution]

you need to insert this at the beginning of your script:

set verbatim = 1;

Normally QV does not take into account leading spaces.

But with above statement QV will take into account leading spaces!

[Tatynout]

Thank you very much it works perfectly! 🙂