This content has been marked as final. Show 4 replies
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 ?