Join table with different lengths
10 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Matt J
le 21 Mai 2020
innerjoin(Grouped_Weight_position{i},Country)
4 commentaires
John Navarro
le 10 Juin 2020
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
le 10 Juin 2020
Modifié(e) : John Navarro
le 10 Juin 2020
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)
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!