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.

NullsDetectedAndConverted: LOAD *, If(IsNull(ValueNullConv), 'T', 'F') as IsItNull; LOAD *, If(len(trim(Value))= 0 or Value='NULL' or Value='-', Null(), Value ) as ValueNullConv; LOAD * Inline [ID, Value 0, 1,NULL 2,- 3,Value];

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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?