Hello, I want to merge two rows containing different fields, is it possible? The result of my query is: | field1 | field2 | fileld3 | field4 | | 1 | 4 | | | | | | 5 | 7 | But I want to get: | field1 | field2 | fileld3 | field4 | | 1 | 4 …

Hi @eloparco You can use the join function do to this as long as you have one column whose value is unique to just the records you want to join.

Merge two rows into one

mhall119 September 7, 2021, 2:43pm 6

Can you share the Flux queries you have for both sets of data?

Topic		Replies	Views
Merge fields into one row, even with different timestamps? Fluxlang schema , time , query , flux , join	0	25	January 22, 2025
Different measurements with some same field name InfluxQL influxql , query	1	638	August 8, 2022
How to combine two tables and filter based on one tables field InfluxDB 2 influxdb , query , flux	3	1175	May 24, 2022
Help with querying several fields from the same point InfluxDB 2	1	363	November 2, 2020
Combine two Rows Fluxlang query , flux	14	4020	April 27, 2021