Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bibopipo
Contributor II

Which type of join ?

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Which type of join ?

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

2 Replies
MVP
MVP

Re: Which type of join ?

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

bibopipo
Contributor II

Re: Which type of join ?

THANKS !! IT WORKS

Community Browser