Syntax
DENULLIFY(<any>; <any>)
Description
Converts null values (represented by ω) to non-null default values. All non-null values are left untouched.
...
| Data field type | Column1 | DENULLIFY returns |
|---|---|---|
| Integer | 1 | 1 |
| Integer | null (ω) | 0 |
| Integer | 3 | 3 |
| Float | 1.1 | 1.1 |
| Float | null (ω) | 0.0 |
| Float | 2.2 | 2.2 |
| Date | Sep 19, 2008 11:13:27 AM | Sep, 19 2008 11:13:27 AM |
| Date | null (ω) | Jan, 01 1970 12:00:00 AM |
| Date | Nov, 25 2010 11:56:13 AM | Nov, 25 2010 11:56:13 AM |
| String | "test1" | “test1" |
| String | null (ω) | "" (an empty string) |
| String | "test3" | "test3" |
| Boolean | true | true |
| Boolean | null (ω) | false |
| Boolean | false | false |
| List (as of Datameer X v5.2)List | null | [ ] (empty list)List (as of Datameer X v5.2) |
| List | [1,2,3] | [1,2,3] |
Example 2
=DENULLIFY(#Column1;"123456789")
...