Discussion Board for collaboration on QlikView Scripting.
I have a short question and maybe you can help me.
In the first table there are all customers with all details inside and in the second Table there are customers I have to exclude during the load process of table 1.
connection between both tables is Customer ID
Data that should be in QlikView File visible: Customer 1, 2 and 3
Hope you can help, cheers
I think you could use an inner join with the second table using the not exists function.
Load Table2 first and then load Table1
Load Customer from table2source;
Load Customer, x,y,z, ...etc from table1source
where not exists(Customer);
Drop table Temp;
LOok the atach