MATLAB Answers

Join table with different lengths

7 views (last 30 days)
Mario Diaco
Mario Diaco on 21 May 2020
Edited: John Navarro on 10 Jun 2020 at 18:48
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.

  0 Comments

Sign in to comment.

Answers (1)

Matt J
Matt J on 21 May 2020
innerjoin(Grouped_Weight_position{i},Country)

  4 Comments

Show 1 older comment
Matt J
Matt J on 21 May 2020
You're welcome, but please Accept-click the answer, since it seems to have fulfilled what you were looking for.
John Navarro
John Navarro on 10 Jun 2020 at 18:33
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 on 10 Jun 2020 at 18:40
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)

Sign in to comment.

Products


Release

R2020a

Translated by