topic Re: Mapping new values in QlikView

Mapping new values

Fri, 23 May 2014 10:47:09 GMT

Hello,

I have a customer table wich contains custome number, SalesmanG and SalesmanB. For most

of our customers are the two salesman fields filled with values and SalesmanG do I like to copy into the invoice tqble

by a mapping. If there are no values for the salesman I like to add a default value. I have tried this code but it doesnt work.

I know that customer SE005037 do not have any salesman and the field inv_salesman should have value SE999900.

See the code and result in attached files.

kindly

Håkan

maxgro — Fri, 23 May 2014 11:27:11 GMT

create a tablebox with

Custnumber1

SalesmanG

inv_salesman

and check if SalesmanG is null or blank for SE005037

it should be null if SE005037 is only in Invoice

better if you can post your data or just an extract to check the issue

Fri, 23 May 2014 12:30:20 GMT

Hello Massimo,

se my app.

Håkan

maxgro — Fri, 23 May 2014 12:47:09 GMT

try to replace your Map_salesman1 with (change in bold)

Map_salesman1:

MAPPING LOAD

Custnumber1,

SalesmanG as Salesman1

Resident Customer_Read

where len(trim(SalesmanG))>0

;

why?

SE005037 is in Customer_Read table with blank SalesmanG

you load SE005037, blank in Map_salesman1

you get blank (not missing --> not SE999900) when you applymap in Invoice

with my change (bold) you esclude the blanks in Map_salesman1

you get missing in applymap (Invoice load)

etc........