Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Not applicable
Author

THANKS !! IT WORKS