View Source

The IFMISSING function writes out a specified value if the source value is a null or missing value. Otherwise, it writes the source value. Input can be a literal, a column reference, or a function.

The ISMISSING function simply tests if a value is missing. See ISMISSING Function.
Missing values are different from null values. To test for null values, see IFNULL Function.

Tip: Since this function captures both missing and null values, you may first wish to address the rows with null values using the IFNULL or ISNULL functions. Any remaining rows that are matched based on this function are exclusively missing values.

ifmissing(my_score,'0')

Output: Generates a new column called, final_score, which contains the value 0 if the value in my_score is a null or missing value.

ifmissing(column_string, computed_value)

Argument	Required?	Data Type	Description
source_value	Y	string	Name of column, string literal or function to be tested
output_value	y	string	String literal value to write

source_value

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

Missing literals or column values generate missing string results.
Multiple columns and wildcards are not supported.

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

output_value

The output value to write if the tested value returns a null or missing value.

Required?	Data Type	Example Value
Yes	String or numeric literal	`'Missing input'`

source_value

output_value

Example - IF* functions for data type validation