Borrar filtros
Borrar filtros

Using the outerjoin to join more than 2 tables

27 visualizaciones (últimos 30 días)
Mark Rodger
Mark Rodger el 30 de En. de 2018
Comentada: Devin kIM el 9 de Nov. de 2020
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 comentarios
Jan
Jan el 30 de En. de 2018
No, you did not use the outerjoin function, but the join function.
Mark Rodger
Mark Rodger el 30 de En. de 2018
Yeah, meant to say join instead of outerjoin

Iniciar sesión para comentar.

Respuestas (1)

Jan
Jan el 30 de En. de 2018
Editada: Jan el 8 de Jun. de 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 comentarios
Jan
Jan el 8 de Jun. de 2018
Editada: Jan el 8 de Jun. de 2018
@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 el 9 de Nov. de 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...

Iniciar sesión para comentar.

Categorías

Más información sobre Loops and Conditional Statements en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by