Discussion board where members can get started with Qlik Sense.
I have an excel spreadsheet that contains 2 separate tables one under the other . They are separated by a blank row. The top table has a permanent amount of rows (4 + headers). The structure of the spreadsheet cannot be changed.
I want to load them as 2 separate tables.
I can easily set the beginning of the dataload for the bottom table by setting the correct number in "header is x lines".
Is there a way to limit the amount of rows uploaded from the top table?
|Properties||option 1||Option 2|
|Color Prices||Option 1||Option 2|
Solved! Go to Solution.
Maybe like this?
load * where key<=4;
load *,RecNo() as key;
FROM [lib://source/Limit rows.xlsx]
(ooxml, embedded labels, table is Feuil1);
drop field key;
1. yes - i can name ranges in the spreadsheet. how can use the named ranges in the script?
2. yes- the top table will always have the same number of rows. The bottom table will vary. Based on my answer can I limit the number of rows I load from the top table? what's the script expression for this?
You can also fix it script-wise - below the two areas are loaded sequentially and the number of row's loaded is limited in the first load-statement and the number of header rows are adjusted in the second load-statement: