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

IsNull and IsEmpty Functions in Kusto Query Language | Kusto Query Functions | KQL Tutorial 2022 Azure Data Explorer is a fast, fully managed data analytics service for real-time analysis on large volumes of data streaming from applications, websites, IoT devices, and more. Ask questions and iteratively explore data on the fly to improve products, enhance customer experiences, monitor devices, and boost operations. Quickly identify patterns, anomalies, and trends in your data. Explore new questions and get answers in minutes. Run as many queries as you need.

Script:
//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 ''Add less than sign here''|
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)

kusto query language tutorial
KQL Tutorial
Kusto Query Language - Azure Training
Kusto from Basic to Advance level
Complete Kusto Query language tutorial from beginner to Advance
Kusto Query Language (KQL) from Scratch
Kusto Query language quickstart
Azure Data Explorer and the Kusto Query Language

#AzureDataExplorer #ADX #KustoQuery

[gauravjoshi]

Nice info can we replace null value with specific value based on logic here is my problem. I want to fill row 3, 4 with value 20
id value
1 10
2 10
3
4
5 20

[ch.shravya]

How to replace null value with array in KQL?