The ISMISSING function tests whether a column of values is missing or null. For input column references, this function returns true or false.

delete row:ISMISSING(Qty)

Output: Deletes any row in which the value in the Qty column is missing.

delete value:ISMISSING(column_string)

ArgumentRequired?Data TypeDescription
column_stringYstringName of column or string literal to be applied to the function


Name of the column or string literal to be tested for missing values.

Multiple columns can be specified as an array, as in the following:

delete value:ISMISSING([col1,col3,col5])


Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - Type check functions