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 valuesKusto 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 

3 comments:

  1. The drop loop you creat is fantastic I think you're good in programming just like me I'm good in Cheap Assignment Service London, I provide this service since 2017. I think you understand how difficult is this to handle lots of students and their thousands of request without any automation.

    ReplyDelete
  2. Weightage for the 9th Rajasthan Board in 2023 Blueprint for the BSER 9th Class in 2023 Weightage for the 9th Rajasthan Board in 2023 Students in the ninth grade who are seeking for BSER 9th Blueprint 2023 can get it from the Rajasthan board. It will be announced on the board's official website as the BSER 9th Blueprint 2023. The 9th grade test was held by the Rajasthan board. The board examination was held throughout the state of Rajasthan. Rajasthan 9th Weightage 2023 When the board announces BSER 9th class Weightage 2023 in the first week of June, we will update this site as soon as possible. Weightage for the 9th Rajasthan Board in 2023 The official website for the BSER 9th Blueprint 2023 is BSER 9th Weightage 2023.

    ReplyDelete
  3. Brothers/Sister's. Are you looking for loan to finance your large or small business,we'll help you get the large amount of loan you desire for your business,we offer first class business and commercial loan to enable small scale business attain success in obtaining start up or refinance their business Bad credit rating accepted and poor business performance are accepted.apply today

    Are you a business man or woman? Do you need funds to start up your own business? Do you need loan to settle your debt or pay off your bills or start a nice business? Do you need funds to finance your project? We Offers guaranteed loan services of any amount and to any part of the world for (Individuals, Companies, Realtor and Corporate Bodies) at our superb interest rate of 3%. For application and more information send replies to the

    via email ronniefinancehome247@gmail.com
    Whats App +91 93118 56893
    LOAN APPLICATION FORM
    Name:
    Sex:
    Address:
    Occupation:
    State:
    Country:
    Phone Number:
    Loan Duration:
    Loan Needed:
    Have you applied before?:
    Email us ronniefinancehome247@gmail.com
    Whats-App +91 93118 56893
    Dr. Mark Thomas

    ReplyDelete