How to replace the 3rd column element of a matrix by comparing 1st and 2nd column of another matrix?

I have a matrix
A =
1 2 5
1 3 5
1 4 5
1 5 6
2 3 6
2 4 7
3 4 7
3 5 7
4 5 7
and
B=
1 2 3
1 3 4
1 4 5
1 5 6
2 3 4
2 4 5
3 4 5
3 5 6
4 5 6
i want to compare 1st and 2nd column and replace the element of 3rd column of B
for example,
in A when 1st and 2nd column is
[1 2] in 3rd column its corresponding value is 5
so i want to replace B's 3rd column whenever in 1st and 2nd column are 1 2
same way when [1 3] it's value will be updated in B in same format.
please help me...
with regard
Suchismita

 채택된 답변

Have a look at ismember(V,B(:,1:2),'row')

댓글 수: 2

I was doing this way and was getting error,
[lo,ii] = ismember(B(:,1:2),A(:,1:2)
out = B;
out(lo,3) = A(ii(lo),3)
now i know where was the error...thank u once again

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

도움말 센터File Exchange에서 Multidimensional Arrays에 대해 자세히 알아보기

질문:

2015년 5월 6일

댓글:

2015년 5월 6일

Community Treasure Hunt

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

Start Hunting!

Translated by