4 Replies Latest reply: Jun 14, 2011 7:01 AM by Johan Idh RSS

    Data loss when loading from local file

    janiuusihannu Jun 14, 2011 6:34 AM

      Hi,

       

      I am trying to read in a flat file with 210K rows and 45 columns. Somehow I only get in about 117K rows (and all columns). My file is Unicode format (UTF-8) and the load script is as follows:

       

      Table:

      LOAD *

       

      FROM

      FILE.TXT(txt, utf8, embedded labels, delimiter is '|', msq, header is 7 lines, filters(

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

      Remove(Col, Pos(Top, 1))

      ));

       

      I do a transformation of the data removing couple of extra rows and columns and selecting the header is on 7th row. However, I have also tried the load using an edited file, where this transformation is not necessary, the same end result.

       

      Is there possibly a limitation to maximum rows in the QlikView load script, that I haven't figured out?