Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator 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

2 Replies
JonnyPoole
Employee
Employee

Use the First command:

First 1000

Load

     *

from <QVD file>;

its_anandrjs

Hi,

Then try to load like

Load * From a.qvd where

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


Regards

Anand