Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want those rows from the first table which has no matching rows exits in second table:
Thanks
Use joins
http://community.qlik.com/forums/t/17453.aspx.. kindly go through this llink. in that link attached a document refer that one.
hope it helps u
http://community.qlik.com/forums/t/17453.aspx
or you can use
where not exists()
Hi,
I am not getting what exactly you are trying to say. I want the do the following operation:
[SQL Statement 1]
MINUS
[SQL Statement 2]
Hi,
I am not getting what exactly you are trying to say. I want the do the following operation:
[SQL Statement 1]
MINUS
[SQL Statement 2]
Im also new in QV. Hope you get something from here.
table1:
load * from sample1;
table2:
load * from sample2
where not exists(id_field);
Or in join()
table1:
load * from sample1;
table2:
outer join(table1)
load * from sample2;
If i wrote something wrong please correct me.
i recommend it to see from Qlikview help.