Union of two matrices with different column size

I need to make the union between two matrices:
M 455799x3
N 771719x3
I attach the workspace with the two matrices inside. What I have to do is to insert the values that are in the 3rd column of M in the 3rd column of N. The first 2 columns of both the matrix represent X coord and Y coord but the problem is that the coordinates of the matrices are not in the same order.

 Accepted Answer

>> [idm,idn] = ismember(M(:,1:2),N(:,1:2),'rows');
>> N(idn,3) = M(idm,3);
Note that the provided data are floating point, so you should definitely read this:

More Answers (0)

Categories

Find more on Operators and Elementary Operations in Help Center and File Exchange

Asked:

on 15 Dec 2017

Edited:

on 15 Dec 2017

Community Treasure Hunt

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

Start Hunting!