Forum Discussion
oliverhuang
Microsoft
Dec 14, 2022KQL How to reference column name if it is a number
How do you reference column name in KQL if it is a number? For example, if I pivot http status code as columns, how do i reference column with "200" as name?
Go to Log Analytics and run query
FunctionAppLogs
| project HostVersion, FunctionName
| limit 100
| evaluate pivot(HostVersion)
| where ['3.17.0.0'] > 9
- Clive_WatsonBronze Contributor
Go to Log Analytics and run query
FunctionAppLogs
| project HostVersion, FunctionName
| limit 100
| evaluate pivot(HostVersion)
| where ['3.17.0.0'] > 9- oliverhuang
Microsoft
thank you!