Pretty much every query language, indeed any coding language, has a form of an if statement. An if statement evaluates a condition for true or false, then takes an action based on that result.
In KQL, this is manifested using the
iiffunction. In this post we’ll see two examples of how an
iifcan be used in your Kusto queries.
Check it out, iif you dare.