Search code examples
azure-application-insightsazure-data-explorer

How to split current item (string) in Azure Application Insights - Kusto Query Language


I'm doing a custom dashboard in Azure Insights, and I'd like to display Exceptions type. In order to do so, I need to split an outerMessage column. I know that there is a split() function, but I don't know how to use it with current item. Any idea how to use split?

exceptions
| project outerMessage

Solution

  • I found it! It was quite intuitive, current item is the name of the column. In my case it was outerMessage. I used new line "\n" as my delimiter.

    exceptions
    | project split(outerMessage, "\n")