Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

gerrycastellino
Contributor III

how to limit record load from qvd file

I have a simple load statement that is loading records from a ".qvd" file that has millions of records.

How do I limit my record load to say 1000 records.

Gerry

Tags (1)
2 Replies
Employee
Employee

Re: how to limit record load from qvd file

Use the First command:

First 1000

Load

     *

from <QVD file>;

Re: how to limit record load from qvd file

Hi,

Then try to load like

Load * From a.qvd where

RowNo() <= 1000;  //This loads only 1000 records


Regards

Anand