How to append 2 tables with different columns

3 views (last 30 days)
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!!!

Accepted Answer

Matt J
Matt J on 14 Feb 2022
Edited: Matt J on 14 Feb 2022
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

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!