| Excerpt |
|---|
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.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | ref |
|---|
| showNote | true |
|---|
| WrangleText | delete row:ismissing(Qty) |
|---|
|
ismissing(Qty) |
Output: Returns true if the value in the Qty column is missing.
| D lang syntax |
|---|
| RawWrangle | true |
|---|
| Type | syntax |
|---|
| showNote | true |
|---|
| WrangleText | delete value:ismissing(column_string) |
|---|
|
ismissing(column_string) |
| Argument | Required? | Data Type | Description |
|---|
| column_string | Y | string | Name 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.
- Missing literals or column values generate missing string results.
- Multiple columns are supported.
- Wildcards are not supported.
| Required? | Data Type | Example Value |
|---|
| Yes | String literal or column reference | myColumn |
Example - Type check functions
| Include Page |
|---|
| EXAMPLE - Type Functions |
|---|
| EXAMPLE - Type Functions |
|---|
|
