Joining 2 tables to make 1 table

Hello,
I have 2 tables. I want to join these tables together to make 1 table.
They have the same number of columns.
What code should I use to joint them?
Thank you.

2 Comments

Are you looking for a different behaviour not provided by table.join?
Sarah Yun
Sarah Yun on 14 Dec 2019
Edited: Sarah Yun on 14 Dec 2019
Hello,
The end of the old table matches the start of the new table.
I just want to join the old and new tables together
The column names are slightly different for the old and new tables - does this matter?

Sign in to comment.

 Accepted Answer

You can unite them as if they were matrixes:
complete_table = [table1 ; table2]; % This should work to join the columns of both tables

More Answers (1)

Sounds like you merely want to vertically concatenate your two tables. The only problem is that they don't have the same variable names, so you'll have to rename the variables of one of them:
table_old.Properties.VariableNames = table_new.Properties.VariableNames; %rename variables in old table. Could do it the other way round
merged = [table_old; table_new]

Categories

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!