Empty Cell not being picked up as NULL

[Anonymous]

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

[hector_munoz]

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