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

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

Anonymous — Tue, 03 Jul 2018 06:43:31 GMT

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

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

neelamsaroha157 — Tue, 03 Jul 2018 16:01:26 GMT

One way is to use Exist function.

Check this out -

Where Exists() and resident load

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

Anonymous — Thu, 05 Jul 2018 13:06:07 GMT

Thank you. The Where Exist works perfectly