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

ismissing(Qty)

Output: Returns true if the value in the Qty column is missing.

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.

 

Required?Data TypeExample Value
YesString literal or column referencemyColumn

Example - Type check functions