Merge many tables

Hi all :wave:

I’m looking for a way to merge many tables together where each table has a unique column name (e.g. June, July, August) along with a unique identifier for each row. Function join() only joins two tables together, and when I use union() the result only from the first table is presented. Not sure what’s going on there. Using a pivot() does not allow me, from what I understand, to specify any table references.

Any suggestions on how I can go about merging more than two tables?

Using join() - only works with two tables
(Because I’m a new user I can only embed one image, so the first one can be found here. Sorry about that. Ping @Franky1 - I guess there is a good motivation behind this, but could this restriction be eased? Thanks!)

Using union() - July data is missing

The idea here is two have at least 12 tables, one for every month of the year.

Thanks in advance!

I’m sorry, I only have moderator status and not administrator status, so I can’t do anything about that. However, as far as I know, the forum software has certain restrictions for new members to limit abuse.

Furthermore, posting pictures is sometimes a bad habit and not necessary. Most of the time it is much better to post a code block. You can do that easily with Markdown syntax here in the forum:

Post your (flux) code here

“Furthermore, posting pictures is sometimes a bad habit and not necessary.”

I would also add that several people (including myself) are on this forum in
mailing-list mode, which means that postings get sent to the recipient by
email, and can be replied to (which then goes back to the forum). However,
images are not relayed in the messages - only unclickable links showing that
there is a picture, but you have to go back to the forum web interface to see

Therefore, to achieve the widest audience for answering your questions, avoid
images unless absolutely necessary.

For code and error messages, copying and pasting text works very well.


No worries.

Agreed. I however felt that a picture would be more convenient to include the output of each example, as CSV format does not play nicely out-of-the-box with markdown. Maybe there is a neat modifier that makes a table out of it? :slight_smile:

Ah, that makes sense and definitely adds to the reasoning. Thanks for letting me know about that!

Thanks both!