Discussion Board for collaboration on QlikView Scripting.
I have two tables , TableA & TableB
I want the all the records in TableA but exclude the common records in both the Tables.
Load table like this
LOAD * Inline
] Where not Exists(C1,C2);
LOAD * INLINE [
,ID as ID2
DROP Table Table2;
Resident Table1 where IsNull(ID2)<>0 ;
DROP Table Table1;
You can use Where not Exists() as Anand suggested, if not then attach some sample data and expected output.
Load the tables like below script this will remove the duplicate records from your tables means common records and keep only uncommon records
LOAD *,'Tab1' as Flag;
LOAD *,'Tab2' as Flag;
Count(Flag) as Flag
Group By ID
Order By ID;
DROP Tables Temp,Temp2;
Output you get
which is uncommon it both tables.
Select data from TableA excluding common records between TableA and TableB
Select col1,col2 from TableA
select col1,col2 from TableB
Simply just use the function not Exist().
If not then you can try the other methods as well.