Combine multiple rows of one column element to an json stringed array

InfluxDB 2
, ,
1

Hi Team,

I need to know if there is any function or way to combine multiple rows of one column element to an json stringed array or json array.

I have rows like this

image
image1242×114 17.5 KB

I want data in one row like -
[{“assetId”:“e5d34f7eed48fd8f89b89194468d6b99”,“latitute”:60,“longitude”:60}, {“assetId”:“01c8374e6d9b52fbbe1add427b10ddc4”,“latitute”:60,“longitude”:60}]

Is it possible?

I am using InfluxdbOSS 2.2

Thank you.

2

Hi @debnath,
Could you try findcolumn() to achieve this?

 |> findColumn(fn: (key) => key.measurment == "foo", column: "jsonStr")

This should return an array of all values in your jsonStr column.