How to compare two matrices of different dimentions and get the result in new column

Hi everyone,

i wanne compare data in two column and get the result in a new column if my condition is true.

A = [2000;1950 ; 1980;2500 ; 2000 ; 5000 ; 2300 ;2000'];

B = [2;2;1;3;1;5;3;3 ; 2;3];

wanne go through all value in B and write in new column when they meet/ equal to 2000.

many thanks

/SA

[Alex Mcaulley]

The question is not clear to me. What is the expected result in your example?

[Stephen23]

ShayanA's "Answer" moved here:

Hi there,

actually wane go through two column (A & B )and find out all the data in B which is equal to 2000 in A.

then wanne show the result in new column. if not then NA or Zero in the new column.

hope i could specify better now :)

Thanks

SA

Answer 1

[Fabio Freschi]

Try this

% find logical indices in A with 2000
idxLog = A == 2000;

% create the new vector with B values in idxLog and zeros in ~idxLog
Bnew = zeros(size(B));
Bnew(idxLog) = B(idxLog);

However it is still puzzling me why A and B have different dimensions

Answer 2

[Andrei Bobrov]

Bnew = B.*(A == 2000);

Answer 3

[ShayanA]

I appreciated Andrei & Fabio

Shayan