Tables: Left Outer Join without changing key names
8 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Christoph
am 25 Nov. 2015
Kommentiert: Christoph
am 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.
0 Kommentare
Akzeptierte Antwort
Kirby Fears
am 25 Nov. 2015
Tell outerjoin to merge the keys.
c = outerjoin(a,b,'Type','left','MergeKeys',true);
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!