Is it possible to join bucket tables?

I am looking for a way to join tables generated in flux.
For example, I do a very broad query:

from(bucket: "my_bucket")
  |> range(start: -1d)

This generates something like this on the photo below:


As you can see, the third column is called table and there is 0, 1, 2, etc.

My question is: how can I join all these tables into a single table?

Hello @snenkov,
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.

Hello @snenkov,
Ah I understand now. Thank you for clarifying. Have you tried using union?


That should make transform your table from multiple tables into one.