Join table with different lengths

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.

Answer 1

[Matt J]

innerjoin(Grouped_Weight_position{i},Country)

[Mario Diaco]

Really easy! Thanks!

[Matt J]

You're welcome, but please Accept-click the answer, since it seems to have fulfilled what you were looking for.

[John Navarro]

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]

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)