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

column_string

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