How to handle Null Values in CSV flie

[#1]

Hi,

How to handle Null Values in CSV flie

[ngulliver]

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 ?

[#3]

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.

[tresB]

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?

[#5]

hi

see link, hope this helps you.

NULL handling in QlikView

[laujerry]

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

[#7]

Hi,

  You can use the function length as well.

   len(field_name)<0  as null_field

    -Jay

[godfreydaniels]

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

Set NullInterpret = '';