Which value must a cell in a csv have, to be identified as NULL-value?

[jisephcirspy]

I've got a csv file and the NULL-values are only identified as String values which contain 'NULL'. How can I change them to real NULL-values or what has to be in a cell in the csv file to be identified as NULL-value by Qlik?

[jyothish8807 · Accepted solution]

Hi @jisephcirspy 

You  can simply write in your script like this: for example field "product" have this string 'NULL' as entry then

Load

Date,

if(Product= 'NULL' , Null() , Product )  as Product

from <>;

Br,

KC

[jisephcirspy]

Thank you very much @jyothish8807!

[jyothish8807]

You are welcome 🙂 Please close the thread by marking the correct answer if the solution helped.

Have a great day ahead!

Br,

KC