IsNull
The IsNull() function checks whether an element has no value assigned (i.e., it is null).
Related functions: IsElement, IsDate, IsDefined, IsNullOrEmpty
Syntax:
IsNull(Element)- In the Quintessence Editor (Studio) using Python language, use:
Qx.IsNull()
ⓘ See parameter descriptions
| Element | Any input value. |
Remarks:
- It is generally recommended to use IsNullOrEmpty, which provides broader detection of missing values.
Examples:
The examples provided below are based on fictitious data for illustrative purposes only.
> Example 1: Check if each value in an array is null
Range:
| 12/23/2014 |
| -1 |
| ABCD |
| FALSE |
| (Blank cell) |
| 46001 |
Formula:
return := IsNull(Range);Result:
| FALSE |
| FALSE |
| FALSE |
| FALSE |
| TRUE |
| FALSE |
