View Source

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

You can define a conditional test in a single step for valid values. See IFMISSING Function.
Missing values are different from null values. To test for the presence of null values exclusively, see ISNULL Function.

ismissing(Qty)

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

ismissing(column_string)

Argument	Required?	Data Type	Description
column_string	Y	string	Name of column or string literal to be applied to the function

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

Required?	Data Type	Example Value
Yes	String literal or column reference	`myColumn`