Discussion board where members can get started with QlikView.
I am new to qv, can you please help me on this?
I have two tables.
I want to remove the records in Table A those are available in Table B.
How can i achieve this? Exist or not exists function or any other one?
use noconcatenateand drop table B or rename fields otherwise syntetic keys are build
noconcatenate Load * from A
where not exisits(Product);
View solution in original post
Load table b first then load table a with a where condition like
where not exists(Product);
B:Load * from B;
Load * from A
It is giving whole 10 records Bro since it is concatenating.
you can usu noconcatenate