Using the outerjoin to join more than 2 tables
古いコメントを表示
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 日
回答 (1 件)
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 件のコメント
Nick George
2018 年 6 月 7 日
編集済み: Nick George
2018 年 6 月 7 日
is this a joke? this is the best solution matlab offers for a very common operation? This answer https://www.mathworks.com/matlabcentral/answers/404380-outer-join-of-multiple-tables is nicer than nesting... but it is still a loop. Both python and r allow passing lists of data frames/tables as an argument to *_join.. I am surprised..
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...
カテゴリ
ヘルプ センター および File Exchange で Entering Commands についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!