Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I'm very new to Qlikview, I need to load multiple xls files in that need to read a specific row, could anyone of help me on this please.
thanks,
Hema
You can try this as well -
table:
first 3 LOAD
*
from sometable;
Thank you all for the response, got a correct solution.
To load just the 3rd row, you can add a where clause to the load like this
LOAD
*
FROM myfile.xls
WHERE RecNo()=3
;
-Rob
Hi,
If you have only 3 rows excluding headers in all the excel files. Use either of the below 2 approaches.
1. using transformation you can delete the unnecessary rows. For this use the below From statement for your load statement.
Test:
Load * FROM
(ooxml, embedded labels, table is Example, filters(
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2))
));
2. When loading select the below setting shown in the image and rename the headers as you need.
.
Hope it helps you..
Hello everyone, To write loop condition
It is continued with my previous question, below is my xls sheet- need to read from row 83(UGTX1000) to 103 (till blank) and it also read the data’s in Purple color which is linked to row 83. The same thing has to be read in multiple xls sheets.
I used where condition but it only read row 83.
I know we can read my loop condition but don’t know much on that, may I know how to get the solution?