Application Insights Kusto (KQL): How to sort items produced by make_set operator

Question

I'm trying to group different kinds by a version. Here is the simplest repro/example:

let Source = datatable(Name:string, Version:string)
[
    'Car', '1.0.0',
    'Train', '2.0.0',
    'Train', '1.0.0',
    'Car', '2.0.0'
];
Source
| summarize make_set(Name) by Version

Right now the the kinds appear according to the order of individual records:

As a result it is hard to compare lines. Wonder how to make items sorted in make_set.

question from:https://stackoverflow.com/questions/66068955/application-insights-kusto-kql-how-to-sort-items-produced-by-make-set-operato

Answer 1

You could use array_sort_asc() / array_sort_desc():

• https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/arraysortascfunction
• https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/arraysortdescfunction

For example:

let Source = datatable(Name:string, Version:string)
[
    'Car', '1.0.0',
    'Train', '2.0.0',
    'Train', '1.0.0',
    'Car', '2.0.0'
];
Source
| summarize Names = array_sort_asc(make_set(Name)) by Version