Facet Operator in Kusto Query (KQL) Generate Tables for each Column in Kusto Query Language 2022

Topic:  Facet Operator in Kusto Query (KQL) Generate Tables for each Column in Kusto Query Language

In this article, we are going to learn about facet Operator in Kusto Query Language, facet operator returns a set of tables, one for each specified column, Each table specifies the list of values taken by its column an additional table can be created by using the ‘’With’’ clause. Kusto Query Language is a powerful tool for exploring your data and discovering patterns, identifying anomalies and outliers, creating statistical modeling, etc.

 // facet operator : Returns a set of tables, one for each specified column. Each table specifies the list of values taken by its column  
 //. An additional table can be created by using the with clause.  
   
 TotalSale  
 | facet by SalePersonFName,SalePersonLName,ProductName  
   

   
 //Add new table by using with  
 TotalSale  
 | facet by ProductName,SalePersonLName  
  with (where Region =="Asia" | take 2 )  

Video Demo:  Facet Operator in Kusto Query (KQL) Generate Tables for each Column in Kusto Query Language