Pass values to qvd

[jpjust]

All,

I need a help here.

I have an script as below 

[ALLIDS]:

LOAD

IDnumber

trandate

FROM [lib://qvd1.qvd](qvd);

[Product]:

LOAD
IDnumber
cost
productname

status

FROM [lib://product.QVD](qvd);

What I would like to do is, just pass the IDnumber from [ALLIDS] to [Product] table.

So that [Product] table returns records only for the IDnumber that is present in [ALLIDS] table.

How to achieve it?

Thanks

[rwunderlich · Accepted solution]

Add Where Exists(IDnumber) to the Product load.

[Product]:
LOAD
IDnumber
cost
productname
status
FROM [lib://product.QVD](qvd)
Where Exists(IDnumber)
;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[jpjust]

Thank you so much Rob!! Awesome.