Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ananyaghosh
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: How to fetch only 100 rows from an excel data?

Hi,

Use this:

First 120

LOAD

*

FROM....

View solution in original post

6 Replies
Partner
Partner

Re: How to fetch only 100 rows from an excel data?

Hi,

Use this:

First 120

LOAD

*

FROM....

View solution in original post

MVP
MVP

Re: How to fetch only 100 rows from an excel data?

LOAD

....

FROM ...

Where recno() <=100;

Partner
Partner

Re: How to fetch only 100 rows from an excel data?

Hi,

LOAD Date,

     Year,

     Month,

     Sales

FROM

(ooxml, embedded labels, table is Sheet1)

where RecNo()<=100;

prma7799
Honored Contributor III

Re: How to fetch only 100 rows from an excel data?

first 120 LOAD

*

FROM

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

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

Partner
Partner

Re: How to fetch only 100 rows from an excel data?

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

Partner
Partner

Re: How to fetch only 100 rows from an excel data?

Hi,

you can use

First 120 before your LOAD statement

First 120

Load

*

FROM .......