Effacer les filtres
Effacer les filtres

Tables: Left Outer Join without changing key names

18 vues (au cours des 30 derniers jours)
Christoph
Christoph le 25 Nov 2015
Commenté : Christoph le 26 Nov 2015
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.

Réponse acceptée

Kirby Fears
Kirby Fears le 25 Nov 2015
Tell outerjoin to merge the keys.
c = outerjoin(a,b,'Type','left','MergeKeys',true);
  1 commentaire
Christoph
Christoph le 26 Nov 2015
Great, exactly what I was looking for, thanks!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by