Condition for qvd

[jagannalla]

Hi,

I want to retrive the data based on conditon for qvd file.

For eg:

Load X,Y,Z fom XYZ.qvd;

if A contains the data from 10 to 50. i want to retrive the data from 20 to 30 only when it is loading.

i.e like between conditon...

Load X,Y,Z fom XYZ.qvd where A between 20 and 30

[disqr_rm]

You can load min and max values of A first and based on that you can then load the data.

Something like:

LOAD max(A) as MaxA,

           min(A) as MinA

FROM XYZ.qvd(qvd)

GROUP By 1;

Then using peek you can load MaxA and MinA values:

LET vMax = peek('MaxA');

LET vMin = peek('MinA');

Then finally load your data by putting if conditions for vMax and vMin variables.

If vMin = 10 and vMax = 50 then

     Load X,Y,Z fom XYZ.qvd (qvd) where A >= 20 and A <= 30;

else

     Load X,Y,Z fom XYZ.qvd (qvd);

endif

Is this something would help you?

Rakesh