NULL - script and chart function
The Null function returns a NULL value.
Syntax:
Null( )
Example: Data load script
In this example, an inline table with four rows is loaded, where the first three lines contain either nothing, - or 'NULL' in the Value column. We want to convert these values to true NULL value representations.
The middle preceding LOAD performs the conversion using the Null function.
The first preceding LOAD adds a field checking if the value is NULL, just for illustration purposes in this example.
This is the resulting table. In the ValueNullConv column, the NULL values are represented by -.
ID | Value | ValueNullConv |
IsItNull |
---|---|---|---|
0 | - | T | |
1 | NULL | - | T |
2 | - | - | T |
3 | Value | Value | F |