Forum Discussion
oliverhuang
Microsoft
MicrosoftKQL 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
Go to Log Analytics and run query
FunctionAppLogs
| project HostVersion, FunctionName
| limit 100
| evaluate pivot(HostVersion)
| where ['3.17.0.0'] > 9
oliverhuangthank you!
