4 Replies Latest reply: Nov 15, 2011 3:22 AM by Andreas Dippel RSS

    [XLS LOAD] limit number of lines being loaded

      good morning,

       

      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 ?

      thanks