How to unpivot columns in kusto/kql/azure and put multiple columns into one
I got a table like this in Azure analytics with Kusto for the game I'm working on datatable (ID_player:string, Timestamp:timespan, monster1:int, monster2:int, monster3:int) [ "aaa", "12:00:00", 1,2,3 ,"aaa", "12:10:00", 4,7,0 ,"bbb", "12:30:00", 0,2,1 ] Basically, I need to switch to…