topic Re: Pass values to qvd in App Development

Pass values to qvd

jpjust — Tue, 25 Jan 2022 20:10:05 GMT

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 — Tue, 25 Jan 2022 20:20:58 GMT

Add Where Exists(IDnumber) to the Product load.

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

jpjust — Tue, 25 Jan 2022 20:34:01 GMT

Thank you so much Rob!! Awesome.