In writing queries, it is not uncommon to get results where a column has missing values. This can cause concerns or questions from your users. “Why is this blank?”, “There must be something wrong with your query its missing data!”.
To avoid this, Kusto provides two functions to check for missing values:
isempty. You can combine this with the
iiffunction (covered in the Fun With KQL – IIF post) to provide clarifying text to the end user.
Check out the examples of how to use these two functions in Robert’s post.