Using the outerjoin to join more than 2 tables
    18 views (last 30 days)
  
       Show older comments
    
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 Comments
Answers (1)
  Jan
      
      
 on 30 Jan 2018
        
      Edited: Jan
      
      
 on 8 Jun 2018
  
      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 Comments
  Devin kIM
 on 9 Nov 2020
				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...
See Also
Categories
				Find more on Tables in Help Center and File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!