Hi. Is there any simple way to convert the value of each measurement to multiple fields in another measurement? I’m using the InfluxDB 1.8, (I will update to 2.0 when setting up a new server).
So I have three measurements (t1, t2, m3), each measurement “inside” has a tag (meter_id), value, and timestamp.
The thing I want to achieve is to create a new measurement called readings with the tag meter_id (based on a meter_id from one of the measurements), three fields t1,t2,m3(based on the value of each measurement), and timestamp (based on a timestamp from one of the measurements, because they have a slight difference in milliseconds).
I’m a new user of InfluxDB and my knowledge is pretty limited, so every piece of information is like gold worth. I enclose below the graphical representation of what I want to achieve.