nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I make a graph from data in multiple data tables without physically joining the tables?

MedianRooster10

I have 2+ data tables with the same columns and I want to produce a graph using all the tables. Previously, I have concatenated them and used the resulting table however this produces lots of extra tables. Is there a way to essentially concatenate them without physically creating a new table?

( Also, want to automate this process if possible.)

Accepted answers

jthi

@MedianRooster10 wrote:
Previously, I have concatenated them and used the resulting table however this produces lots of extra tables

There should be no need to create any extra tables. You can append them together and close the tables you don't need (you should end up with just one data table).

All comments

jthi

@MedianRooster10 wrote:
Previously, I have concatenated them and used the resulting table however this produces lots of extra tables

There should be no need to create any extra tables. You can append them together and close the tables you don't need (you should end up with just one data table).

MedianRooster10

Thank you for your reply, however I would like to keep the original table as is.

I analyse table A to produce some graphs then would like to combine with table B to produce a different set of graphs. I may want to go back to table A to do some more analysis.

Is there an alternative way to what you have suggested?

jthi

During first concatenation create new table and concatenate rest of data to that (this way you keep table 1 as it was and rest will be concatenated to the new table just created). Also if you leave Source column to your table, you can use Data filters to exclude other tables from the data.