Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
try to replace your Map_salesman1 with (change in bold)
SalesmanG as Salesman1
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)
create a tablebox with
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
se my app.