extracting data from matrix

Hello every bod
let assume matrix
A =
[10 20 1
30 40 2
50 60 3
70 80 4
90 100 5]
B =
[30 40
70 80]
we need to identify the third column of the matrix B, hence
B =
[30 40 2
70 80 4]

Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 16 Jul 2016
Edited: Azzi Abdelmalek on 16 Jul 2016
A= [10 20 1
30 40 2
50 60 3
70 80 4
90 100 5]
B=[30 40
70 80]
idx=ismember(A(:,1:2),B,'rows')
B(:,3)=A(idx,3)

2 Comments

I tried this code for other different matrices I get a problem at which the third column is not compatible with the first and 2'nd column data in terms of ordering
Azzi Abdelmalek
Azzi Abdelmalek on 16 Jul 2016
Edited: Azzi Abdelmalek on 16 Jul 2016
Can you explain? post an example to make your question clear

Sign in to comment.

Categories

Tags

Asked:

on 16 Jul 2016

Edited:

on 16 Jul 2016

Community Treasure Hunt

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

Start Hunting!