Scalar FunctionsDynamic / JSON Functions
column_ifexists
If a column named `column_name` exists in the current row set, return its value for the current row; otherwise evaluate and return `default`. Resolved at query compile time, so the column name must be a constant string and the default's type is ignored when the column exists.
Syntax
column_ifexists(column_name, default)Parameters
Prop
Type
Returns: any
Examples
Example 1
datatable(a:int)[
1,
2,
3
]
| project resolved = column_ifexists("a", 0), missing = column_ifexists("nope", - 1)| resolved (int) | missing (long) |
|---|---|
| 1 | -1 |
| 2 | -1 |
| 3 | -1 |