MATLAB: Compare two tables and extract data

ismember

Hello, I have two data matrix: A and B 
A =
   101    62
   102    65
   103    62
   104    58
   105    72
   106    80
 
B =
    99    65
   100    62
   102    80
   104    71
   105    73
   109    62
I would like to search all same values in first column of A and B, and create a column C with all the extracted rows from A and B :
   C = 
   
    102    65    80 
    104    58    71
    105    72    73
Any help is very much appreciated!

Best Answer

Try this
A = [
    101    62
   102    65
   103    62
   104    58
   105    72
   106    80];
B = [
    99    65
   100    62
   102    80
   104    71
   105    73
   109    62];
[idxA, idxB] = ismember(A(:,1), B(:,1));
C = [A(idxA, :) B(idxB(idxB~=0), 2)];
Related Question