Topic: Kusto Query strcat How to Concatenate Columns in Kusto Query Language
In this article, we are going to learn how to concatenate columns in Kusto Query language or some value that we need to concatenate, 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.
///strcat : Concatenates between 1 and 64 arguments. If the arguments aren't of string type, they'll be forcibly converted to a string.
.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
///strcat : Concatenates between 1 and 64 arguments. If the arguments aren't of string type, they'll be forcibly converted to a string.
//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,River
4,steve,Ladson
5,Robert,Jr
//Print and concate multiple values
print strcat("Aamir"," ","Shahzad", "Age", 43) // Notice 43 is added but space is ignored
print strcat("Aamir"," ","Shahzad"," ","Age ", 43,' Does single quotes work') // yes you can add string in single quotes
print strcat(Aamir, ' ' , Shahzad) // Can you add string values without quotes?
print strcat(6, ' ' , 4) // Can you add string values without quotes?
print strcat('"Aamir"', ' ' , 'Shahzad') // How to Add double quotes in string concatenation
print strcat('Aamir','Fraction: ',45/2.0,' ','WholeNumber:' ,45,' decimals' ,56.8888) // What will happen to decimical and fractions
//Use strcat for table columns to generate new columns
TotalSale
| project id,SalePersonFName,SalePersonLName,FullName=strcat(SalePersonFName,' ',SalePersonLName)
No comments:
Post a Comment