topic Re: excel in QlikView

excel

Mon, 15 Dec 2014 05:26:11 GMT

Hi,

In my excel some records are there.

but i dont want to load first 1000 records.

How to solve this issue?

Regards

Anil

ashfaq_haseeb — Mon, 15 Dec 2014 05:28:32 GMT

Hi,

Try like this

for first 1000

First 1000

LOAD *

FROM

[yourexcel.xls];

for Greater then 1000

LOAD *

FROM

[yourexcel.xls] where rowno()>1000;

Regards

ASHFAQ

anbu1984 — Mon, 15 Dec 2014 05:37:59 GMT

Load * From ExcelFile Where RecNo() <= 1000;

its_anandrjs — Mon, 15 Dec 2014 05:44:17 GMT

Hi,

Then try this way for rows greater than 1000 rows.

Load * From

ExcelSource Where RecNo() > 1000;

Load * From

ExcelSource Where RowNo() > 1000;

Regards

Anand

its_anandrjs — Mon, 15 Dec 2014 05:54:13 GMT

Hi Anil,

By RecNo() <= 1000 you get only records from 1 to 1000 did you check the result of this expression it should be RecNo() > 1000.

Just for curiosity

Regards

Anand