Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to specify how many lines to load from an Excel file? I have a very large Excel file that somehow got ~900K blank rows (with ~450 columns) that are treated as data. This causes Excel/QlikView to crash when I try to work with the data. I would like to be able to load say only the first 2,000 lines of the file into QlikView if possible.
Thanks.
in your script use First keyword before load statement...something like below:
MyTable:
First 2000
Load
....
from ....;
Hi noah,
use a RecNo() in where clause...WHERE RecNo() <=2000;
BR
M
When I do
LOAD cccqs_0,
cccqs_1,
cccqs_2,
cccqs_3,
cccqs_4,
cccqs_5,
cccqs_6,
cccqs_7,
cccqs_8,
cccqs_9,
cccqs_10,
cccqs_11,
cccqs_12,
cccqs_13,
cccqs_14,
cccqs_15,
cccqs_16,
RecNo()
FROM
(ooxml, embedded labels, table is Sheet3)
WHERE RecNo <=2000;
I get a Script Error that says "Field not found - <RecNo>.
in your script use First keyword before load statement...something like below:
MyTable:
First 2000
Load
....
from ....;
you are missing brackets after RecNo....it is a function. but simpler approach is using keyword "First"
Thanks! This works.
you can also use noofrows function