Extract values by matching column values

16 views (last 30 days)
novice modeler
novice modeler on 10 May 2017
Commented: novice modeler on 11 May 2017
Friends, I have two matrices, a and b. a= [ 1 2 3 ; 4 5 6] and b = [1 2 3 4 ; 4 5 6 10]. I want to extract the fourth column of matrix b by matching first three columns of a & b.
Thanks

Answers (1)

Andrei Bobrov
Andrei Bobrov on 11 May 2017
[C,ia,ib] = setxor(a',b','rows');
out = C';

Categories

Find more on Modeling in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!