Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pick First rows!!!!

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

5 Replies
sudeepkm
Specialist III
Specialist III

you can use Where clause in your load script.

Where RowNo()<=999

Not applicable
Author

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 .... ;


talk is cheap, supply exceeds demand
maxgro
MVP
MVP

first  1000

Load

     ......

     .....

MK_QSL
MVP
MVP

First 1000

Load

....

From...