Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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