| Excerpt |
|---|
The NULL function generates null values. |
- The
ISNULL function tests for the presence of null values. See ISNULL Function. - Null values are different from missing values.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value:null() |
|---|
|
null() |
Output: Returns a null value.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | derive type:single value: if((isnull(FirstName) || isnull(LastName)), null(), 'ok') as:'status' |
|---|
|
if((isnull(FirstName) || isnull(LastName)), null(), 'not null') as:'status' |
Output: If there are null values in either the FirstName or LastName column, generate a null value in the status column. Otherwise, the returned value is not null.
There are no arguments for this function.
Example - Type check functions
| Include Page |
|---|
| EXAMPLE - Type Functions |
|---|
| EXAMPLE - Type Functions |
|---|
|
