Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
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 - Specialist
Partner - Specialist

Hi,

Use this:

First 120

LOAD

*

FROM....

View solution in original post

6 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Use this:

First 120

LOAD

*

FROM....

swuehl
MVP
MVP

LOAD

....

FROM ...

Where recno() <=100;

ankitaag
Partner - Creator III
Partner - Creator III

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 - Champion
Partner - Champion

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 - Specialist III
Partner - Specialist III

Hi,

you can use

First 120 before your LOAD statement

First 120

Load

*

FROM .......