Combining two matrices using two criteria

 h = [1 4 11;
      2 5 12;
      4 7 13]

 y = [1 4;
      2 5;
      3 6;
      4 7]

I want for each row of matrix y to detect the first two elements in matrix h that are the same as matrix y and then copy the third element of the detected row in matrix h in a new third column in matrix y. The result should be

l = [1 4 11;
     2 5 12;
     3 6  0;
     4 7 13]

I can't figure out the code for this.

[the cyclist]

Is this homework?

What have your tried?

[Mido]

I am new to MATLAB and I have two large datasets with millions of observations. I want to combine them by transferrring some values from one matrix to another when the first two elements in each row are the same in both. After that, I will get the complete one like l matrix (The last matrix) in my example and then I can do analysis.

Answer 1

[KSSV]

clc; clear all ;
h = [1 4 11;
      2 5 12;
      4 7 13] ;
 y = [1 4;
      2 5;
      3 6;
      4 7] ;
% check positions of h in y 
[val,idx] = ismember(h(:,1:2),y,'rows','legacy') ;
% initilaize required matrix 
iwant = zeros(size(y,1),3) ;
iwant(:,1:2) = y ;  
iwant(idx,3) = h(:,3)

[Mido]

Thanks for you help again. I really appreciate if you recommend a book or a manual that I use to learn MATLAB.

[Image Analyst]

See this link: http://www.mathworks.com/matlabcentral/answers/8026-best-way-s-to-master-matlab