Transform a value field into Null

[#1]

Hello,

I am working in a project in which some of the data source comes from CSV. When I load those data, there is some fields with strings values, written as 'NULL'. In QV this will not really count as null.

Is there way for me to convert those values to a proper NULL?

Is this condition script enough to achieve the goal?

If (FieldName= 'NULL', ' ', FieldName)

Thank you in advance!

Iuri

[MK_QSL]

'NULL' to Null() Suggested by you is the best till date I have used..

[MarcoWedel]

test data

[MarcoWedel]

Hi,

I might be missing something here, but I think 'NullInterpret' does exactly what you are looking for.

It defines a string that will be interpreted as 'real' NULL when loaded.

So a solution might be:

SET NullInterpret='NULL';

table1:
LOAD ID,
    FieldName
FROM [https://community.qlik.com/servlet/JiveServlet/download/940087-203416/QlikCommunity_Thread_197487.cs...] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

hope this helps

regards

Marco

[sunny_talwar]

I tried it with an Inline table and it did not work. I will try to see if I still have that sample