Is there a "Virtual Concatenate"?Hello! I am trying to combine 8 tables together and update automatically if the original table (be it excel or JMP data table).
- The 8 tables have the same column names and properties, they just have different data sets, so what I am technically trying to do is concatenate all of them together.
- I also need the joined table (that the 8 feed into) to be able to update if the data in the feeder tables are added/removed, etc.
I know there is a "join" that can create a database which will virtually update with changes to the input data tables, but that function is not working for my needs because it just replaces the data ("join" function on JMP); it does not concatenate.
Is there a function to concatenate 8 data tables (preferably excel) virtually such that the concatenated data table (the one with all 8 original data tables combined) will update if the feeder data tables are changed?
Thank you in advance!
Data TableRe: Is there a "Virtual Concatenate"?Thanks @gzmorgan0 for the suggestions, I added some more details.
Ah, ok, thanks:(A bit unfortunate. I'm not familiar with SQL, but I'm open to learning/trying it out if it's simple/straightforward.
