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

How to fetch only 100 rows from an excel data?

ananyaghosh — Mon, 27 Apr 2015 12:32:22 GMT

Hi,

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

Thanks,

Sandip

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

fvelascog72 — Mon, 27 Apr 2015 12:34:14 GMT

Hi,

Use this:

First 120

LOAD

FROM....

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

swuehl — Mon, 27 Apr 2015 12:34:36 GMT

LOAD

....

FROM ...

Where recno() <=100;

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

ankitaag — Mon, 27 Apr 2015 12:39:50 GMT

Hi,

LOAD Date,

Year,

Month,

Sales

FROM

(ooxml, embedded labels, table is Sheet1)

where RecNo()<=100;

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

prma7799 — Mon, 27 Apr 2015 12:40:33 GMT

first 120 LOAD

FROM

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

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

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

awhitfield — Mon, 27 Apr 2015 15:03:56 GMT

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

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

Gabriel — Mon, 27 Apr 2015 15:16:47 GMT

Hi,

you can use

First 120 before your LOAD statement

First 120

Load

FROM .......