Getting not maching row of a table

[#1]

Hi,

I want those rows from the first table which has no matching rows exits in second table:

Thanks

[#2]

Use joins

[#3]

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

[#4]

http://community.qlik.com/forums/t/17453.aspx

[#5]

or you can use

where not exists()

[#6]

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]

[#7]

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]

[#8]

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.

[#9]

i recommend it to see from Qlikview help.