Create an array using the column by query query

InfluxDB 2
1

Hi, I am using InfluxDB 2.0.4 and flux language for queries.

In the documentation, the array has been introduced as the composite data type.

I want to create the array using any column(it can be a tag or field) which comes as query output.

Suppose, I am running a flux query and got 2-3 columns as output columns["_value","_field","City","_measurement"].

Now, I want to make two arrays of _value and City columns separately.

I checked InfluxDB documentation but it’s not mentioned anywhere how to create an array from the query output.

Can you please help me with how can I create the array from the query output column or any documentation URL for the same?

2

Helo @Ravikant_Gautam,
I’d check out findColumn function:

Pro tip: You can use the following syntax if theres only one table in your results steam.

|> findColumn(fn: (key) => true,  column: "_value")

Lmk if that helps.