topic Re: Which type of join ? in QlikView

Which type of join ?

Anonymous — Tue, 09 Oct 2012 21:39:18 GMT

Dear all,

I've two tables like these:

Table1

OrderID Customer

1 A

2 B

3 C

4 D

Table2

OrderID OrderDetail Product

1 1 zz

2 1 yy

4 1 xx

I need to extract only the ORDERID without any entry into Table2. In this case the OrderID 3

How can I solve it ?

Help please

Thanks in advance

swuehl — Tue, 09 Oct 2012 22:14:29 GMT

If you have already loaded your two tables into QV, you should be able to do it like this (untested):

TMP:

LOAD

OrderID as OrderIDTable2

resident Table2;

MissingIDTable:

LOAD

OrderID as MissingOrderID

resident Table1 where not exists(OrderIDTable2, OrderID);

Hope this helps,

Stefan

Anonymous — Fri, 12 Oct 2012 20:02:08 GMT

THANKS !! IT WORKS