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,




      (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?