Topic: Print Operator in Kusto Query Language
Print Operator in Kusto Query | Kusto Query Language Tutorial (KQL) 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. A Kusto query is a read-only request to process data and return results. The request is stated in plain text, using a data-flow model that is easy to read, author, and automate. Kusto queries are made of one or more query statements.
//Print Function
// Can be used to print out values
print 'TechbrothersIT'
print "Aamir Shahzad"
//Perform some calculations and print results
print 4*3
// Give name to results ( Column Name)
print results= 4*3
//Use Variable and Print Variable Value
let abc=4;
print abc;
//Save results of Query in variable and then print
let RecordCount = TotalSale
| count;
//print TotalRecords = toscalar(RecordCount)
//Save results of Query in variable and then print
let TotalItemsSold = TotalSale
| summarize sum(ItemsSold);
//print TotalRecords = toscalar(TotalItemsSold)
//Print Multiple Variables
print ItemCount = toscalar(RecordCount), ItemSold = toscalar(TotalItemsSold)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.