Pick First rows!!!!

[#1]

Hi,

       I have flat file and i want pick a first 1000 rows in my flat  to Qlikview

      any one help how we do this

[sudeepkm]

you can use Where clause in your load script.

Where RowNo()<=999

[#3]

Hi,

Try this:

Tbl1:

LOAD  *

FROM

[abc.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where RecNo()<=1000

;

[Gysbert_Wassenaar]

Use the First keyword:

FIRST 1000

Load .... from .... ;

[maxgro]

first  1000

Load

     ......

     .....

[MK_QSL]

First 1000

Load

....

From...