Discussion board where members can get started with QlikView.
i have a LARGE excel file, with many sheets. usually, there is only one table per sheet.
but in this case, there are sheets with like 7 diferent tables (with different types of data)
qlikview allows to ignore a number of lines before it starts to load (header).
BUT, is there a way to STOP the load after a certain amount of lines ?
because, if it continues to load, it creates data-garbage after a few lines
(f.e. reading names, after a few lines there are numbers in the same column = mixed numbers and names)
any suggestions ?
Go to Solution.
You can use a where clause:
(biff, no labels, table is sheet1$)
You can replace the 1000 by the number of lines you want to load.
where RowNo()<100; works
when there are f.e. 10 excel files, it reads all the necessary data from file1 OK,
BUT QV reads only the first line of data from the following files.
Please, try using recno() instead of rowno(), this way you can control the load on each input table.
You are right, this was allready solved in: