How to append 2 tables with different columns

4 次查看（过去 30 天）
Shaochen Hu
Shaochen Hu 2022-2-14
评论： Shaochen Hu 2022-2-14
I have 2 tables T1 and T2.
T1=3×2 table
Var1 Var2
____ ____
'A' 1
'B' 2
'C' 3
T2=3×2 table
Var1 Var3
____ ____
'D' 4
'E' 5
'F' 6
Is there a convenient way for me to get a combined table T3 like this?
T3=6×3 table
Var1 Var2 Var3
____ ____ ____
'A' 1 NaN
'B' 2 NaN
'C' 3 NaN
'D' NaN 4
'E' NaN 5
'F' NaN 6
Appriciated for your help!!!

请先登录，再回答此问题。

采纳的回答

Matt J
Matt J 2022-2-14
编辑：Matt J 2022-2-14
Ran in:
Use outerjoin().
T1=table(('ABC')',[1,2,3]');
T2=table(('DEF')',[1,2,3]'+3,'Var',{'Var1','Var3'});
outerjoin(T1,T2,'MergeKeys',1)
ans = 6×3 table
Var1 Var2 Var3 ____ ____ ____ A 1 NaN B 2 NaN C 3 NaN D NaN 4 E NaN 5 F NaN 6

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by