How can I merge two different tables using the first column in common?

A(class double)

[1  7;
 3 15]

B(class double)

[2  9;
 5 10]

C = (A+B)

[1   7   0;
 2   9   0;
 3  15   0;
 4   0   0;
 5   0  10]

[Adam]

What is the logic behind that merging?!

[the cyclist]

The rule seems to be

1. merge and sort on the first column of both arrays
2. put corresponding values from A into 2nd column of C
3. put corresponding values from B into 3rd column of C

I think that the second row of C is supposed to be

[2 0 9]

[Fernando Dos Santos]

yes! Thank you

Answer 1

[the cyclist]

A = [1  7;
     3 15]

B = [2  9;
     5 10]

Ca = [A, zeros(size(A,1),1)];
Cb = [B(:,1), zeros(size(B,1),1), B(:,2)];

M1 = union(A(:,1),B(:,1));
M2 = setdiff((1:max(M1))',M1);
M3 = [M2, zeros(size(M2,1),2)];

C = sortrows([Ca; Cb; M3],[1]);

[Fernando Dos Santos]

Thank you

[Adam Danz]

This question came up again 4 years later but needed to work with 3 matrices. The question and answer is here:

https://www.mathworks.com/matlabcentral/answers/463294-follow-up-how-can-i-merge-two-different-tables-using-the-first-column-in-common

[Jos (10584)]

answerS! :-)