Merge more that two tables together

12 次查看（过去 30 天）
HabenG
HabenG 2021-11-4
编辑： HabenG 2021-11-4
Is there a way to merge multiple tables? I am trying to use outerjoin and innejoin functions to merge multiple tables but it does look like thats possible, Is there a way around this?

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

采纳的回答

Dave B
Dave B 2021-11-4
You can nest joins:
outerjoin(t3, outerjoin(t1, t2))
Or in a loop, if you have an array of tables:
tbls={t1 t2 t3 t4};
tjoin=tbls{1};
for i = 2:numel(tbls)
tjoin=outerjoin(tjoin, tbls{i})
end
  1 个评论
HabenG
HabenG 2021-11-4
编辑：HabenG 2021-11-4
Much appreciated!! I added mergekeys to keep one variable constat and it did the trick.
tbls = {T1 T2 T3 T4 T5 T6 T7};
tjoin = tbls{1};
for i = 2:numel(tbls)
tjoin = outerjoin(tjoin, tbls{i},"MergeKeys",true);
end
And if anyone is looking for innerjoin here is a fuction for it....
tjoin_inner = rmmissing(tjoin);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by