Join table with different lengths

14 次查看（过去 30 天）
Mario Diaco
Mario Diaco 2020-5-21
编辑： John Navarro 2020-6-10
Hi!
I have 2 types of tables.
In the first type of table "Country", I have stored a data for each country (Var2, in the example screenshoot):
The second type of table "Grouped_Weight_position{i}", has the follow form:
I would join in the second type of table (Grouped_Weight_position{i}) the data (Var2) from the first type of table (Country) only if in the second type of table exist the same country. Would anyone know how to show me a way?
Thank at all.

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

回答（1 个）

Matt J
Matt J 2020-5-21
innerjoin(Grouped_Weight_position{i},Country)
  4 个评论
显示 2更早的评论
John Navarro
John Navarro 2020-6-10
Thanks Matt J.
I have a similar case, but I want combine all "Countries" but I requiere it to create a NaN value (or zero) for those countries that are not in both tables.
In other words, i need to know which countries have all the information and which one do not.
Any idea? Thanks
John Navarro
John Navarro 2020-6-10
编辑：John Navarro 2020-6-10
It just make it works by using
C = outerjoin(A,B,'Keys',{'Country'},'MergeKeys',true)
% Where A and B are the corresponding Tables to merge.
BUT, It wont work if you use the automatic code that is generated by the Task option in the live script
C = outerjoin(A,B,'Type','left','Keys',{'Country'},'MergeKeys',true)

请先登录，再进行评论。

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by