'kql - datatable with one cell from an array

How can I create a datatable with one cell from an array?

I have this as an input:

let arr = dynamic ([
    "Harjumaa",
    "Tallinn",
    "Lastekodu",
    "24",
    ""
]);

This code works:

let dt = datatable(value:dynamic)
[
    dynamic([
        "",
         "Harjumaa",
         "Tallinn",
         "Lastekodu",
         "24",
         ""
    ]), 
];
let cleanedArr = dt
| mv-apply value on (
    summarize value = make_list_if(value, isnotempty(value))  
);
print toscalar(cleanedArr);

but I need to use arr variable as an input

arraysdatatablekql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions