topic Re: How to load limited rows from Excel in QlikView

How to load limited rows from Excel

Tue, 16 Sep 2014 14:31:45 GMT

I want to load rows 1 to 10 and 21 to 30 from an excel table, but not 11-20 and everything above 30.

I use Where Recno<=10 in load script,

but how to load rows 21-30 in the same time?

Thanks in advance !

Tue, 16 Sep 2014 14:42:00 GMT

Table:

Load

Filedname,

recno()

from sourcetable;

Final:

Load

Filedname,

recno()

resident Table where recno<=10 and Recno>20;

maxgro — Tue, 16 Sep 2014 14:48:29 GMT

I think you can use recno with and or

LOAD @1, @2, @3

FROM [1.xls] (biff, no labels, table is Sheet1$)

where RecNo() <= 10 or (RecNo() >= 21 and Recno() <=30)

;

mjayachandran — Tue, 16 Sep 2014 15:01:14 GMT

Something like this should satisfy both your conditions:

YourTable:

LOAD *

FROM

$(Path)

(ooxml, embedded labels, table is Sheet1)

where

RecNo()>=1 and RecNo()<=10 or

RecNo()>=21 and RecNo()<30;