kusto & concat string array

Jonas Samuelsson - Jul 7 '22 - - Dev Community

From time to time I want to summarize a kusto query by a combination of multiple values.

One way to do that is to concat them all manually, like this

strcat(cloud_RoleName, "-", application_Version, "-", resultCode)
Enter fullscreen mode Exit fullscreen mode

During investigations I often want to change which values I group by and writing the query like this simplifies that

strcat_array(pack_array(cloud_RoleName, application_Version, resultCode), "-")
Enter fullscreen mode Exit fullscreen mode
. . . . . . . . . . . . . . . .
Terabox Video Player