Happy Holidays! Draw a tree with KQL
Published Dec 21 2021 02:10 PM 1,283 Views

KQL isn't just super-powerful, it's also fun!
See how you can draw a tree using KQL and learn some of the functions and operators available.
Inspired by https://lnkd.in/eCgFzBTw. Feel free to design and share your own trees!

 

 

let tree_height = 10;
range i from 0 to tree_height * 2  step 2   
| extend side_width = tree_height + 1 - i / 2
| extend side_space = strcat_array(repeat(" ", side_width), " ")
| project Happy_Holidays = case(i != 0, strcat(side_space, "O", strcat_array(repeat("V", i - 1), ""), @"O", side_space), 
strcat(side_space, " O", side_space))

 


Holidays.png

 

 

let L=10;
range x from 1 to L step 1
| project t=strcat(strrep(' ', L-x), strrep('.', x), strrep('*', x-1))
| summarize Tree=make_list(t)
| project Tree=array_concat(pack_array(strcat(strrep(' ', L-3), make_string(127775))), Tree)
| project HappyXmas=strcat_array(Tree, '\n')

 


Holidays2.png
 

 

Version history
Last update:
‎Dec 21 2021 03:27 PM