How to add two tables

18 次查看(过去 30 天)
JFz
JFz 2015-9-23
评论: JFz 2015-9-24
I have two tables of different number of rows but with same structure. They both have 3 columns, the 3rd column is numbers. How to create a new table which has the common rows on column 1 and column2 and sum on column 3?
Thanks.
Jennifer

采纳的回答

Kirby Fears
Kirby Fears 2015-9-23
编辑:Kirby Fears 2015-9-23
Hi Jennifer,
Here's code with sample data that performs your task.
data=magic(3); % sample data
% creating sample tables 1 and 2
table1=array2table(data,'VariableNames',{'key1','key2','values'});
table2=array2table(data,'VariableNames',{'key1','key2','values'});
% joining tables on key1 and key2 only
tablejoin=join(table1,table2,'Keys',{'key1','key2'});
% add value columns together and delete the extra column
tablejoin.values_table1=tablejoin.values_table1+tablejoin.values_table2;
tablejoin.values_table2=[];
Hope this helps.
  5 个评论
JFz
JFz 2015-9-24
I tried to use innerjoin but I got 0 row in the resulting table.
JFz
JFz 2015-9-24
Hi,
Thanks Kirby,
I got it! I used innerjoin on two table and it worked!

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Logical 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by