IsNull and IsEmpty Functions in Kusto Query Language | Kusto Query Functions | KQL Tutorial 2022

 Topic: IsNull and IsEmpty Functions in Kusto Query Language

In this article we are going to learn about isempty and isnull function in custom isempty can be used to find out if a string data column value is empty isnull can be used for integer type columns so these both functions can help us to find empty or null values. Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQL's: databases, tables, and columns.

 //isempty and isnull  
 //isempty can be used to find out if string data column value is empty. is null can be used for integer type columns  
 //Let's create a table Customer  
 //.drop table Customer  
 .create table Customer (CustomerId: long, FName: string,LName:string )   
  .ingest inline into table Customer <|  
 1,Aamir,Shahzad  
 2,Raza,ALI  
 3,Lisa,  
 4,steve,Ladson  
 5,Robert,Jr  
 ,aamir,ali  
 // get all records so you can see empty rows  
 Customer  
 // get all records where integer type column has null values  
 Customer  
 | where isnull( CustomerId)  
 //get all records where string type columns are empty  
 Customer  
 | where isnull(LName) // this does not work on string type columns  
 Customer  
 | where isempty( LName)  

Video Demo: IsNull and IsEmpty Functions in Kusto Query Language