2 Replies Latest reply: Apr 28, 2015 4:40 PM by Steve Dark RSS

    won't recognise the Null value in a text file

    Adam Wilson

      I have a text file (attached) that I am loading in as a fixed width table as below:

       

      LOAD @1:40,

           @41:n

      FROM

      NullData.txt

      (fix, codepage is 1252);

       

      however QlikView is unable to read the NULL values in the file which I need it to recognise otherwise the fixed width boundaries don't work. Opening it in Notepad++ I can see the NULL values, so I dont know why QlikView can't see them.

       

      can anyone help?