The |
ISMISSING
function simply tests if a value is missing. See ISMISSING Function.Tip: Since this function captures both missing and null values, you may first wish to address the rows with null values using the |
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 |
Name of the column, string literal, or function to be tested for missing values.
Required? | Data Type | Example Value |
---|---|---|
Yes | String literal, column reference, or function | myColumn |
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' |