12 Replies Latest reply: Jan 13, 2015 9:26 AM by Pierre Philippon RSS

    Fetching issue - Excel - Too many lines loaded - Takes time

      Hello

       

      I am fetching data from an Excel workbook. Each Excel sheet is laoded into a Qlikview table.

      All goes smoothly except for one sheet where 13,000,000 lines are fetched even though I only have 80,000 data point. The structure of the sheet is very similar from the other sheets in the same workbook, and in the other cases there is no problem.

      Any idea/suggestion?

       

      The cript loading the data is:

       

      Table:

      CrossTable(ID, DATA, 1)

      LOAD *

           FROM

      [file.xlsx]

      (ooxml, embedded labels, table is DATA, filters(

      Remove(Row, Pos(Top, 2)),

      Remove(Row, Pos(Top, 2)),

      Remove(Row, Pos(Top, 2)),

      Remove(Row, Pos(Top, 2))

      ));

       

      Thank you very much