Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dt_adamwilson
Contributor

won't recognise the Null value in a text file

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?

Tags (4)
2 Replies
eruditio
Contributor III

Re: won't recognise the Null value in a text file

Try opening it in Excel, and you'll see how QlikView  is reading it the same way.

I feel that you might have to perform some data manipulation if you are in a hurry.


MVP
MVP

Re: won't recognise the Null value in a text file

Hi Adam,

I know this is an old thread, but I have just hit the exact same problem and I was wondering if you found a way around it?

I have pushed back on the data provider to clean their extract process, but even then I have historical files I need to read.

I guess I can parse the files with a VBScript and replace the null values with spaces, but this seems like a large overhead.

Thanks in advance.

Steve

Community Browser