Empty Cell not being picked up as NULL

Anonymous — Wed, 12 Apr 2017 12:42:01 GMT

I have a column of data that contains NULLS and "white space" and I need the "white space" to be identified in some way so I can sort them out and to be able to count the NULLS and "white space".

In my LOAD script I am using:

SET NullValue = '<Unknown>';
NullAsValue *;

Below are the results in the INCIDENT TTF DEADLINE TIMESTAMP field which is a Date field

Suggestions on how to get the "white space" identified?

Thanks!

Dan

Re: Empty Cell not being picked up as NULL

hector_munoz — Wed, 12 Apr 2017 13:32:30 GMT

Hi Dan,

A trick could be If(Len(<field>) > 0 AND Trim(<field>) = 0, <White Space>, [INCIDENT TTF DEADLINE TIMESTAMP]) AS [INCIDENT TTF DEADLINE TIMESTAMP]

Regards;
H

topic Empty Cell not being picked up as NULL in QlikView

Empty Cell not being picked up as NULL

Re: Empty Cell not being picked up as NULL