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 中查找有关 Tables 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by