topic Re: Pick First rows!!!! in QlikView

Pick First rows!!!!

Fri, 25 Apr 2014 12:31:40 GMT

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 — Fri, 25 Apr 2014 12:37:27 GMT

you can use Where clause in your load script.

Where RowNo()<=999

Fri, 25 Apr 2014 12:37:54 GMT

Hi,

Try this:

Tbl1:

LOAD *

FROM

[abc.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where RecNo()<=1000

;

Gysbert_Wassenaar — Fri, 25 Apr 2014 12:38:26 GMT

Use the First keyword:

FIRST 1000

Load .... from .... ;

maxgro — Fri, 25 Apr 2014 12:39:19 GMT

first 1000

Load

......

.....

MK_QSL — Fri, 25 Apr 2014 12:41:46 GMT

First 1000

Load

....

From...