Reassemble Influx query

InfluxDB 2
1

Hello,

I am currently setting up an influxDB. I am using the influxdb-java-client to read and write data to and from the influxDB.
My problem is that i have multiple Field values per Point I am inserting into the DB. This becomes an issue when I want to reassemble the Point again, since Influx splits the Point by its Field values and puts them into different Tables.
I tried using join() but I am struggling with the Flux syntax. Is this the right approach?

Can you help me?

2

Hi @Overflowed,

you have to use pivot() function.

Regards

3

@Overflowed you can use pivot() to shift all the fields into columns based on time:

data
  |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
4

@scott and @bednar
Thanks you two, I made it work with pivot!
Best regards, Overflowed