Limit the number of records from QVD?

[#1]

Hi,

I have 7 QVDs which I am using for my reports. I am just wondering if it is possible to limit the number of records from some of my QVDs and full number of records for others.

If it is possible what could be the load statement to limit (e.g. TOP 10000 only ) records?

I am not sure if we can do it in Partial load.

Please advise.

Thanks,

TA

[Anonymous · Accepted solution]

Hi,

FIRST 10 LOAD * RESIDENT Customers; 

Using the First keyword you can limit the qvd or resident table records.

Regards

Ashok.

[jagan]

Hi,

If you want to load N number of records then you can use

Edit Script -> Debug -> Select "Limit Load" and give number of records to load in below textbox -> Click Run button

Hope this helps you.

Regards,

jagan.

[Anonymous]

Hi,

Here is the script to load statement to limit (e.g. TOP 10000 only ) records:

LOAD

....

FROM

....

WHERE

     RowNo()<=10000; // Here you replace the 10000 by the number of line you need

It works only if you want to limit to the first x lines.