Is it possible to use column name as variable in Kusto?

Question

In Kusto, can I do this?

let my_var = "prefix";
let my_custom_col = strcat(my_var, "_something");
my_tab | extend my_custom_col = "5" 

I tried it but it creates a column with name, my_custom_col not with the name prefix_something.

Is it possible to use a variable as a column name in Kusto?

Answer 1

This is not currently possible in Kusto.

Answer 2

you can use columnifexist function https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/columnifexists