Partial loading of an excel file

[#1]

Hello everybody,

I am new on Qlik and  I have a question.

How can I load only the first 8 lines of an excel file?

I know that if I want to start the load at the third line (for example) I can use the function Header ("ooxml, embedded labels, header is 10 lines, table is ...") but I don't know how to limit the number of lines loaded ...

Thanks a lot,

Matthieu

[m_woolf]

look up First in Help:

First 8

load

...

[Siva_Sankar]

Matthieu,

The syntax is

YourTableName:

First 8 Load * from yourfilename;

See here How to load only 10 or 100 records from any file

Siva

[Siva_Sankar]

More details here in this blog Limited Load and the First Prefix

-Siva

[prma7799]

Try Like this....

[tyagishaila]

you can use First 10 Load * from ABC;

or can debug the app instead off reload, there is an option with name Limited Load to fill no of lines you want to reload.