I am looking for a way to join tables generated in flux.
For example, I do a very broad query:
|> range(start: -1d)
This generates something like this on the photo below:
As you can see, the third column is called
and there is 0, 1, 2, etc.
My question is: how can I join all these tables into a single table?
Yes it’s possible to join data across buckets.
However for the data you shared, can you please just apply a group()?
I understand now (after having used Flux for a while) that from the table above it cannot be deduced how to fix the problem.
In short the issue can be summed like this:
if we have two separated (like shown above) tables, one with columns
A, B, C and the other with
A, B, D. Note that each matching column name has the same column type too.
The question is: can we have a single table, 'A, B, C, D
? By a single table I mean without separations like on the photo I shared. This single table can still have the table` column and show multiple tables.
I hope my explanation makes it clearer.
Ah I understand now. Thank you for clarifying. Have you tried using union?
That should make transform your table from multiple tables into one.