Tables: Left Outer Join without changing key names
12 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Suppose I have two tables:
a = table({'a';'b';'c';'d'},[1;2;3;4],'VariableNames',{'Key','Var1'});
b = table({'a';'c';'e'},[0.1;0.2;0.3],'VariableNames',{'Key','Var2'});
And I do a left outer join:
c = outerjoin(a,b,'Type','left');
This will give me a table with variables 'Key_a', 'Var1', 'Key_b', 'Var2'
But what I would like to have would be a table with only 'Key', 'Var1', 'Var2'
Is there a simple way to do this via option settings, without having to rename manually? For me this would be a hassle, because I have tables with 7+ keys with dynamic names.
0 commentaires
Réponse acceptée
Kirby Fears
le 25 Nov 2015
Tell outerjoin to merge the keys.
c = outerjoin(a,b,'Type','left','MergeKeys',true);
Plus de réponses (0)
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!