Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
look up First in Help:
First 8
load
...
Matthieu,
The syntax is
YourTableName:
First 8 Load * from yourfilename;
See here How to load only 10 or 100 records from any file
Siva
More details here in this blog Limited Load and the First Prefix
-Siva
Try Like this....
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.