Topic: How to Use Extend to Add Calculated Columns in Kusto Query Language.
In this article, we are going to learn about the extend operator that creates a calculated columns and append them to the result set. 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.
// extend operator : Create calculated columns and append them to the result set.
.clear table TotalSale data
.create table TotalSale (
id: int
,SalePersonFName: string
,SalePersonLName : string
,ProductName : string
,ItemsSold : int
,SoldPrice :real
,SoldDate: date
,City : string
,State : string
,Country : string
,Region : string
)
//Insert data
.ingest inline into table TotalSale <|
11,Tamara,Tony,Cell Phone,2,1200,2015-03-03,Frankfurt,Hesse,Germany,Europe
11,Tamara,Tony,Cell Phone,2,1200,2015-03-03,Frankfurt,Hesse,Germany,Europe
9,Petra,Henry,TV,10,5000,2015-04-08,Paris,Île-de-France,France,Europe
3,Christy,Ladson,TV,3,1600,2015-04-02,High Point,NC,USA,North America
7,Chirag,Patel,Cell Phone,5,1500,2015-06-23,AhmadAbad,Gujrat,India,Asia
2,M,Raza,Cell Phone,2,800,2015-07-15,Charlotte,NC,USA,North America
5,Najaf,Ali,Computer,1,300,2015-06-20,Karachi,Sindh,Pakistan,Asia
6,Sukhjeet,Singh,TV,2,900,2015-06-21,ChandiGar,Punjab,India,Asia
4,John,Rivers,Laptop,5,2400,2014-03-09,Jersey City,NJ,USA,North America
8,Aleena,Aman,Laptop,2,800,2015-05-25,Lahore,Punjab,Pakistan,Asia
10,Rita,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
1,Aamir,Shahzad,TV,1,700,2015-07-15,Charlotte,NC,USA,North America
12,aamir,shahzad,TV,1,7000,2015-07-15,Charlotte,NC,USA,North America
id=Null,bisma,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
// extend operator : Create calculated columns and append them to the result set.
//get all columns with data from table
TotalSale
//add a calculated columns
TotalSale
| extend fullname=strcat(SalePersonLName,' ',SalePersonLName),DayofYear=dayofyear(SoldDate)
// extend the columns to result set
TotalSale
| project id,SalePersonFName,SalePersonLName,ItemsSold, SoldDate
| extend fullname=strcat(SalePersonLName,' ',SalePersonLName),DayofYear=dayofyear(SoldDate)
my name is Albert Roy , and I am a student. Just finished reading this article. Excellent Accept my gratitude for your post. How to Use Extend to Add Calculated Columns in Kusto (KQL). you describe this post-January color scheme. I sincerely hope that these suggestions end up being beneficial to you in the future. Excellent post with all the necessary details. But right now, I'm looking for the top writing a report help service for my work. The website is, in my opinion, educative. Students should use it as support, in my opinion. And right now, complete your assignment.
ReplyDeleteIf you need an essay done but are diesel gas stations near me now
ReplyDeleteunsure of your ability to do it, you may go through the profiles of the people who are offered by reviews.
Our Assignment Help in Qatar will deliver you the best quality assignments at an affordable rate. Our team of experts aims to cater to the best solutions in almost every field with assignment help in Qatar. Our customized and well-formatted solutions will enhance your score level without putting heavy weight on your budget. Some reasons for being unable to prepare assignments with quality solutions are a lack of time management skills, lack of guidance, not having in-depth subject understanding, and improper knowledge of formatting style. The benefits of using Gradespire services are discounts and offers, economical prices, expert solutions, privacy policy, well-researched and analyzed assignments.
ReplyDelete