Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator III

How to fetch only 100 rows from an excel data?

Hi,

I have an excel file with 1000 rows, but I want to load only 120 rows. How to do it?

Thanks,

Sandip

1 Solution

Accepted Solutions
fvelascog72
Partner
Partner

Hi,

Use this:

First 120

LOAD

*

FROM....

View solution in original post

6 Replies
fvelascog72
Partner
Partner

Hi,

Use this:

First 120

LOAD

*

FROM....

swuehl
MVP
MVP

LOAD

....

FROM ...

Where recno() <=100;

ankitaag
Partner
Partner

Hi,

LOAD Date,

     Year,

     Month,

     Sales

FROM

(ooxml, embedded labels, table is Sheet1)

where RecNo()<=100;

prma7799
Master III
Master III

first 120 LOAD

*

FROM

[..\..\Downloads\Data Accuracy.xlsx]

(ooxml, no labels, header is 120 lines, table is Sheet1);

awhitfield
Partner
Partner

Hi Sandip,

if this is just for testing purposes, you can also execute the reload from with the debugger and use 'Limited Load' and set the number of records to whatever you want.

Andy

Gabriel
Partner
Partner

Hi,

you can use

First 120 before your LOAD statement

First 120

Load

*

FROM .......