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

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

MedianRooster10 — Fri, 13 Oct 2023 07:52:43 GMT

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.)

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

jthi — Fri, 13 Oct 2023 08:17:26 GMT

@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).

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

MedianRooster10 — Fri, 13 Oct 2023 08:35:24 GMT

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?

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

jthi — Fri, 13 Oct 2023 09:05:50 GMT

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.