How to append 2 tables with different columns

4 visualizaciones (últimos 30 días)
Shaochen Hu
Shaochen Hu el 14 de Feb. de 2022
Comentada: Shaochen Hu el 14 de Feb. de 2022
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!!!

Respuesta aceptada

Matt J
Matt J el 14 de Feb. de 2022
Editada: Matt J el 14 de Feb. de 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

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by