Using the outerjoin to join more than 2 tables

조회 수: 19 (최근 30일)
Mark Rodger
Mark Rodger 2018년 1월 30일
댓글: Devin kIM 2020년 11월 9일
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
Jan 2018년 1월 30일
No, you did not use the outerjoin function, but the join function.
Mark Rodger
Mark Rodger 2018년 1월 30일
Yeah, meant to say join instead of outerjoin

댓글을 달려면 로그인하십시오.

답변 (1개)

Jan
Jan 2018년 1월 30일
편집: Jan 2018년 6월 8일
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
Jan
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
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...

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by