Using the outerjoin to join more than 2 tables

Question

0 个投票

I want to join multiple tables together to make one table. I've used the outerjoin function to join 2 tables together(shown below). Is there anyway to join more than 2 tables using the outerjoin function.

c = outerjoin(data{1,1},data{1,3},'Keys','time','MergeKeys',true);

2 个评论
显示无隐藏无

Jan 2018-1-30

No, you did not use the outerjoin function, but the join function.

Mark Rodger 2018-1-30

Yeah, meant to say join instead of outerjoin

请先登录，再进行评论。

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

Follow Question

Answer 1

Jan 2018-1-30

编辑：Jan 2018-6-8

在 MATLAB Online 中打开

0 个投票

You can nest the joining:

outerjoin(A, outerjoin(B, C))

[EDITED] With a loop:

function Joined = MultiOuterJoin(varargin)
Joined = varargin{1};
for k = 2:nargin
  Joined = outerjoin(Joined, varargin{k});
end
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Jan 2018-6-8

编辑：Jan 2018-6-8

@Nick George: No, I'm not joking. All I did was to show, that it is easy to call outerjoin multiple times. If this is done recursively of by a loop does not matter, because the point is the iterative joining.

See EDITED.

Devin kIM 2020-11-9

I gotta agree with Nick on this one... This can be done in virtually all analysis languages, why is joining multiple tables not available in 2020b? Seems like something that should have been available a long time ago instead of adding more flashy features...

请先登录，再进行评论。

Using the outerjoin to join more than 2 tables

2 个评论
显示无隐藏无

回答（1 个）

3 个评论
显示 1更早的评论隐藏 1更早的评论

类别

标签

Community Treasure Hunt

Using the outerjoin to join more than 2 tables

2 个评论 显示 无 隐藏 无

回答（1 个）

3 个评论 显示 1更早的评论 隐藏 1更早的评论

类别

标签

另请参阅

Community Treasure Hunt

2 个评论
显示无隐藏无

3 个评论
显示 1更早的评论隐藏 1更早的评论