column_ifexists()

Takes a column name as a string and a default value. Returns a reference to the column if it exists, otherwise - returns the default value.

Deprecated aliases: columnifexists()

Syntax

column_ifexists(columnName,defaultValue)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
columnName	string	✔️	The name of the column to check if exists.
defaultValue	scalar	✔️	The value to use if the column doesn't exist. This value can be any scalar expression. For example, a reference to another column.

Returns

If columnName exists, then the column it refers to. Otherwise defaultValue.

Example

Run the query

// There's no column "Capital" in "StormEvents", therefore, the State column will be used instead
StormEvents | project column_ifexists("Capital", State)