Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jisephcirspy
Contributor III
Contributor III

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

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?

Labels (1)
1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

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

Best Regards,
KC

View solution in original post

3 Replies
jyothish8807
Master II
Master II

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

Best Regards,
KC
jisephcirspy
Contributor III
Contributor III
Author

Thank you very much @jyothish8807!

jyothish8807
Master II
Master II

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

Have a great day ahead!

Br,

KC

Best Regards,
KC