hasNull
Syntax
hasNull(X)
Arguments
X is a scalar/vector/matrix/table.
Details
For a scalar, return true if it is NULL.
For a vector, return true if at least one element is NULL.
For a matrix or a table, return true if at least one element of at least one column is NULL.
Please refer to related functions: isNull, nullFill.
Examples
$ hasNull NULL;
1
$ x=00f;
$ hasNull x;
1
$ hasNull 5;
0
$ hasNull(1 2 NULL 4 NULL 6);
1
$ x=((NULL,1),2);
$ hasNull x;
0
$ m=(1 NULL 3 4 5 6)$2:3;
$ hasNull m;
1
$ t=table(`AAPL`IBM`MSFT as sym, 2200 NULL 4500 as qty);
$ hasNull(t);
1