NullAsValue
The NullAsValue statement specifies for which fields that
Syntax:
NullAsValue *fieldlist
By default, QlikView considers
The NullAsValue statement operates as a switch and will operate on subsequent loading statements. It can be switched off again by means of the NullAsNull statement.
Arguments:
Argument | Description |
---|---|
*fieldlist | A comma separated list of the fields for which NullAsValue should be turned on. Using |
Example:
NullAsValue A,B;
Set NullValue = 'NULL';
LOAD A,B from x.csv;