フィルターのクリア

Tables: Left Outer Join without changing key names

20 ビュー (過去 30 日間)
Christoph
Christoph 2015 年 11 月 25 日
コメント済み: Christoph 2015 年 11 月 26 日
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.

採用された回答

Kirby Fears
Kirby Fears 2015 年 11 月 25 日
Tell outerjoin to merge the keys.
c = outerjoin(a,b,'Type','left','MergeKeys',true);
  1 件のコメント
Christoph
Christoph 2015 年 11 月 26 日
Great, exactly what I was looking for, thanks!

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeTables についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by