Load or Display Null Values as "Unknown"

[#1]

I have production status values in a Status field and some rows contain null values. How do I either load or display the null values as "Unknown" ?

[JonnyPoole · Accepted solution]

the isnull() function will check if a value is null.

So in the load editor you could recalculate each status using an IF() expression using isnull() as the condition as follows:

LOAD

     if ( isnull(Status),'Unknown', Status)  as Status,

     otherfields...

from <source>

[jagan]

Hi Jason,

I think handling this in script is a better option, try any one this in script

TableName:

LOAD

*,

Alt(Status, 'Unknown') AS Status

FROM DataSource;

OR

TableName:

LOAD

*,

If(Len(Trim(Status)) > 0, Status,  'Unknown') AS Status

FROM DataSource;

OR

TableName:

LOAD

*,

If(IsNull(Status),  'Unknown', Status) AS Status

FROM DataSource;

Regards,

Jagan.

[#4]

Awesome, thank you Jonathan!