DENULLIFY

Syntax

DENULLIFY(<any>; <any>)

Description

Converts null values (represented by ω) to non-null default values. All non-null values are left untouched.

Integer null values are converted to 0 (zero), float values are converted to 0.0, string null values are converted to empty strings, Boolean values are converted to false, and null date values are converted to Jan 1, 1970 12:00:00 AM.

An additional argument can be entered into DENULLIFY as a default replacement to null values.

Examples

Example 1

=DENULLIFY(#Column1)

Data field typeColumn1DENULLIFY returns
Integer1
1
Integernull (ω)
0
Integer3
3
Float

1.1

1.1
Floatnull (ω)0.0
Float2.22.2
DateSep 19, 2008 11:13:27 AMSep, 19 2008 11:13:27 AM
Datenull (ω)Jan, 01 1970 12:00:00 AM
DateNov, 25 2010 11:56:13 AMNov, 25 2010 11:56:13 AM
String"test1"“test1"
Stringnull (ω)"" (an empty string)
String"test3""test3"
Booleantruetrue
Booleannull (ω)false
Booleanfalsefalse
List (as of Datameer X v5.2)null[ ] (empty list)
List (as of Datameer X v5.2)[1,2,3][1,2,3]

Example 2

=DENULLIFY(#Column1;"123456789")

Data Field TypeColumn1Returns
Integernull (ω)123456789