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

How do you reference fields from different tables using a where clause? and the data you extract it from QVD's file.

How do you reference fields from different tables using a where clause? and the data you extract it from QVD's file.

Example:

Customer:

LOAD Customer_ID

Customer_Name

Address

FROM

(qvd);

Order:

LOAD ORDER_ID

Description

Amount

Order_Date

FROM

(qvd);

Question is how do you select only the orders pertaining certain customer_ID's

Order:

LOAD ORDER_ID

Customer_ID

Description

Amount

Order_Date

FROM

(qvd); Where (Order.Customer_ID = Customer.Customer_ID)

I get an error if i try to do it this way. Can anyone help

2 Replies
neelamsaroha157
Specialist II
Specialist II

One way is to use Exist function.

Check this out -

Where Exists() and resident load

Anonymous
Not applicable
Author

Thank you. The Where Exist works perfectly