Update table from columns of another table

9 次查看（过去 30 天）

Fabio 2021-12-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1615275-update-table-from-columns-of-another-table

评论： Fabio 2021-12-21

Hello everyone,

I have two tables, “Atab” and “Btab”, and I would like to update “Atab” by adding all the columns (variables) and their respective values that are in “Btab” but not in “Atab” (meaning columns “Trans” and “Det”).

See in attached “Atab”, “Btab” and the expected “Output” in jpeg files.

Thanks in advance

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson 2021-12-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1615275-update-table-from-columns-of-another-table#answer_859505

在 MATLAB Online 中打开

Avars = A.Properties.VariableNames;
Bvars = B.Properties.VariableNames;
BnotA = setdiff(Bvars, Avars);
Atab = [Atab, B(:,BnotA)];

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2021-12-21

Perhaps you want innerjoin() based upon rowname

https://www.mathworks.com/help/matlab/ref/innerjoin.html

Fabio 2021-12-21

Yes I would like to innerjoy, but based on the example in the link, I would like that “T” shows as well rows “1” with “Var2” empty and rows “7” and “9” with “Var1” empty.

请先登录，再进行评论。