Update table from columns of another table

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

Answer 1

[Walter Roberson]

Avars = A.Properties.VariableNames;
Bvars = B.Properties.VariableNames;
BnotA = setdiff(Bvars, Avars);

Atab = [Atab, B(:,BnotA)];

[Fabio]

Hello Walter, thanks for your help.

By implementing your code, in the last line MATLAB gives the following error:

All tables being horizontally concatenated must have the same number of rows.

Why is that?

Thanks again

[Walter Roberson]

Perhaps you want innerjoin() based upon rowname

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

[Fabio]

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.