Discussion Board for collaboration on QlikView Scripting.
I hope that you can help me, here is my question:
I have two tables , for example:
How can I extract from the table two only the values that are Not in table1?
I will be very appreciated if somebody knows how to do it.
ps: maybe you know a good book about qlikview?
Go to Solution.
Try to load with Key fields assume this example
Load *,ID From a.csv;
Load *,ID From b.csv;
Load *,ID From c.csv;
Load *,ID2 From a.csv;
Load *,ID2 From d.csv;
Load *,ID2 From e.csv;
Load *,ID2 resident tmpTab2
Where Not Exists(ID,ID2);
Drop table tmpTab2;
Drop Table Tab1;
And read this post may help you
Re: Regarding Exist() function and it's functionality
where not exists(a.csv);
u can simply write below script and your problem will be resolved
PS: About book i have a one tell me ur email id will send it to you.
Thank you very much guys!! each answer is very important for me