Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

load specific number of rows

I want to load with specific number from a db

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

To load the first 100 records:

First 100

Load * from somewhere;


talk is cheap, supply exceeds demand
jagan
Partner - Champion III
Partner - Champion III

Hi,

You can load First n records of the dataset by using First n keyword like this

TableName:

First n

LOAD

     *

FROM DataSource;

where n is replaced with number of records.

Hope this helps you.

Regards,

Jagan.