topic Re: Parsed Information from String to Array in DQL

Parse String Values into Arrays Using Dynatrace DQL

Gib80 — Tue, 27 Jan 2026 10:45:12 GMT

Summary: This thread shows how to parse string data into array structures in DQL. It includes examples of splitting fields and working with the resulting array elements.

Good Afternoon,

Is it possible to convert a string from a parsed command to an array?

This is the parsed command I have.

| parse event.original, """LD 'watchlist":' LD:Watchlist ',' """

I wish to use the sort command below, but it states that watchlist is a string, not an array.

| sort arraySum(Watchlist) desc

Kind regards

Re: Parsed Information from String to Array

krzysztof_hoja — Sat, 05 Oct 2024 11:25:54 GMT

Yes, it is possible and there are many option. Depending on how this array is represented in string, you can use:
https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/functions/string-functions#splitString
or https://docs.dynatrace.com/docs/platform/grail/dynatrace-pattern-language/log-processing-json-array

or https://docs.dynatrace.com/docs/platform/grail/dynatrace-pattern-language/log-processing-array

To advice more precisely example of original filed value would be helpful.

Re: Parsed Information from String to Array

Gib80 — Mon, 07 Oct 2024 07:14:02 GMT

Hi krzysztof_hoja,

The filed value returned from the watchlist parsed command above is "S_PEP"

Kind regards

Preview

Re: Parsed Information from String to Array

krzysztof_hoja — Mon, 07 Oct 2024 13:45:12 GMT

If it is "S_PEP" (not a number), how do you want to calculate "arraySum(Watchlist)" ?

Or maybe you want to order records alphabetically (| sort Watchlist) ?