Concatenate Tables with/without "Join"

Question

Dario Walter 2019-6-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/467522-concatenate-tables-with-without-join

评论： Dario Walter 2019-6-18

采纳的回答： Matt J

在 MATLAB Online 中打开

Hey guys,

I could really need your help right now!

Let us assume

A = table(['A';'B';'C';'D';'E'],[38;43;38;40;49],...
    'VariableNames',{'Character' 'Time1'})
B = table(['A';'C';'D';'E';'F'],[92;46;29;50;57],...
    'VariableNames',{'Character' 'Time2'})
        

I want to create table in such a way that it returns

C=table(['A';'B';'C';'D';'E';'F'],[38;43,38;40;49;nan],[92;nan;46;29;50;57])

Do you have any idea? Thanks for your help!

2 个评论
显示无隐藏无

Matt J 2019-6-17

在 MATLAB Online 中打开

Your code to generate C generates an error

>> C=table(['A';'B';'C';'D';'E';'F'],[38;43,38;40;49;nan],[92;nan;46;29;50;57])
Error using vertcat
Dimensions of arrays being concatenated are not consistent.

And what do you mean by "with/without Join"? Do you mean either is acceptable?

Dario Walter 2019-6-17

在 MATLAB Online 中打开

Please apologize, there was a comma instead of a semicolon.

C=table(['A';'B';'C';'D';'E';'F'],[38;43;38;40;49;nan],[92;nan;46;29;50;57])

Exactly, I do not mind how it works. It just has work.

请先登录，再进行评论。

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

Answer 1

Matt J 2019-6-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/467522-concatenate-tables-with-without-join#answer_379567

编辑：Matt J 2019-6-17

在 MATLAB Online 中打开

>> C = outerjoin(A,B,'Keys','Character','MergeKeys',true)
C =
  6×3 table
    Character    Time1    Time2
    _________    _____    _____
        A          38       92 
        B          43      NaN 
        C          38       46 
        D          40       29 
        E          49       50 
        F         NaN       57 