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

Find more on MATLAB in Help Center and File Exchange

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!