Query Details
Sparkles
Query
//Working with Emoji in queries. See https://cda.ms/3wh for Emoji code reference.
let L=14;
range x from 1 to L step 1
| project t=make_string(10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024, 10024)
| summarize Sparkles=make_list(t)
| project Sparkles=array_concat(pack_array(strcat(strrep(' ', L-1))), Sparkles)
| project Happy_New_Year=strcat_array(Sparkles, '\n')
Explanation
This query is using KQL (Kusto Query Language) to work with emojis. It sets a variable L to 14, then creates a range of numbers from 1 to L with a step of 1. It uses the make_string function to create a string of repeating numbers. It then uses the summarize function to create a list called Sparkles with the make_list function. It concatenates an array of spaces with the Sparkles array and assigns it to a variable called Sparkles. Finally, it concatenates the Sparkles array with new lines and assigns it to a variable called Happy_New_Year.
Details
Rod Trent
Released: December 29, 2021
Tables
range
Keywords
Keywords:let,range,from,to,step,project,make_string,summarize,array_concat,pack_array,strcat,strrep,Happy_New_Year
Operators
letrangefromtostepprojectmake_stringsummarizemake_listarray_concatpack_arraystrcatstrrepstrcat_array