Convert String to Integer in Dynatrace Query Language (DQL)

[nikhilchandra]

Summary: This thread explains how to use DQL functions to convert string values into numeric or integer formats. It includes syntax examples and practical use cases for data transformation in Dynatrace dashboards.

Hi Experts

May i know which function to use to convert string value in to Integer or Number format?

[nikhilchandra]

@Mizső  but i am getting null output, as the input value is a string.

[krzysztof_hoja · Accepted solution]

toLong() conversion function , but the string being parameter needs to be a valid number, otherwise you will get null

data 
  record(s="1"),
  record(s="1.2"),
  record(s="a")
| fieldsAdd i=toLong(s), d=toDouble(s)