Combining multiple tables together

9 views (last 30 days)
Alex Herron
Alex Herron on 19 Jun 2019
Edited: Matt J on 19 Jun 2019
I have 14 tables that I want to combine into one large table. They each have different number of rows, but have the same number of columns (9). The number of rows vary from ~10,000 to ~200,000. I thought it would be easy to combine them by essentially stacking them on top of each other, however I'm struggling to find the right command. I want the combined table to have 9 columns, and the sum of all the rows of the smaller tables.

Answers (2)

Alex Herron
Alex Herron on 19 Jun 2019
just found out that vertcat exists! nevermind!

Matt J
Matt J on 19 Jun 2019
Edited: Matt J on 19 Jun 2019
I thought it would be easy to combine them by essentially stacking them on top of each other
It is that easy,
A=array2table(rand(3,2));
B=array2table(rand(5,2));
C=[A;B]
>> C=[A;B]
C =
8×2 table
Var1 Var2
_______ _______
0.81472 0.91338
0.90579 0.63236
0.12699 0.09754
0.2785 0.97059
0.54688 0.95717
0.95751 0.48538
0.96489 0.80028
0.15761 0.14189

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!