topic Re: How to handle Null Values in CSV flie in QlikView

How to handle Null Values in CSV flie

Wed, 04 Sep 2013 13:12:33 GMT

Hi,

How to handle Null Values in CSV flie

Re: How to handle Null Values in CSV flie

ngulliver — Wed, 04 Sep 2013 15:05:58 GMT

Could you please provide more descriptive information, maybe an example too? Is your issue with reading a .CSV file with nulls in or storing output as a .CSV ?

Re: How to handle Null Values in CSV flie

Thu, 05 Sep 2013 05:23:46 GMT

Thank you for replay....

I have files Sales data.xls,Sales data.csv.in this file i have CustomerID field .

when every i am using NullDisply,NullInterput,nullasvalue,nullasnull it not wrok.....

how to handle null values in CustomerID.

Re: How to handle Null Values in CSV flie

tresB — Thu, 05 Sep 2013 05:38:50 GMT

Hello Prasad,

Prasad Jakkula wrote:

when every i am using NullDisply,NullInterput,nullasvalue,nullasnull it not wrok.....

how to handle null values in CustomerID.

It's not really clear enough to understand your issue. Can you please upload a sample with expected result described?

Re: How to handle Null Values in CSV flie

Thu, 05 Sep 2013 05:58:34 GMT

see link, hope this helps you.

NULL handling in QlikView

Re: How to handle Null Values in CSV flie

laujerry — Thu, 05 Sep 2013 07:16:08 GMT

try checking with IsNull() function to pre-process your data first

Re: How to handle Null Values in CSV flie

Thu, 05 Sep 2013 09:41:21 GMT

Hi,

You can use the function length as well.

len(field_name)<0 as null_field

-Jay

Re: How to handle Null Values in CSV flie

godfreydaniels — Thu, 23 Jan 2020 16:46:13 GMT

NullInterpret takes a different syntax for csv than for QVD. Try:

Set NullInterpret = '';