Creating a new table with the same time value from 2 different tables
2 次查看（过去 30 天）
I have table t1 and t2 (attached) with the different sizes which has two columns (time,number). I want to create a new table if the time of table t1 and t2 are the same, and for the number, I want to have t2(number)+t1(number) with the coincided time.
Can someone help me?
t1 = readtable('t1.xlsx'); %read table t1
t2 = readtable('t2.xlsx'); %read table t2
new_table = innerjoin(t1, t2, 'Keys', 'Var1'); %conduct an innerjoin with key var1
new_table.sum = new_table.Var2_t1 + new_table.Var2_t2; %add the two variables together
This is going to create a fourth variable in the table called sum. That is the var1+var2
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!