Merge two rows into one

Fluxlang
, , ,
1

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   |     5   |    7   |

Is there a transformation that I can use?

2

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.

3

Thanks, that’s what I was about to do.

Since the two rows are coming from different measurements I can have two separate streams, add a fake common column and then do the join.
I was wondering if there was a more direct way without having to generate two separate streams and then join them.

4

Depending on what data you have to create our fake column out of, you may be able to do this with group() in a single query

5

I didn’t find any way to achieve it with the group() operator. The data is similar to what I put in the example.

6

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

7

No sorry I can’t, but in the end I used the join(), thanks to a fake attribute that I add to both the measurements (since otherwise they have nothing in common).
Thank you for your help!