MATLAB: Row position and find value

row position and value

I have having some trouble with locating the position of the row in a table and then using that same row to find the value in column 3.

I first used:

Accelval=find(strcmp(mergetable1{:,1},AccelSN),1) to find the value where the first column matches the variable where the user has an input. The I would like to find the row position of this value. After determining the row position, I must create a new variable that uses the row position to find the value in column 3.

Any suggestions?

Best Answer

Replace

Accelval

with

 [rows, columns] = ... and use the rows to index the table of column 3

Related Solutions

MATLAB: How to find row position of value in a column

Try this:

row = find(yourColumnVector == desiredValue);

Adapt by replacing with the actual names and values of your variables.

MATLAB: Position and extraction of row

It would definitely help to see what ‘mergetable1’ is, and how you are getting ‘AccelSN’.

If ‘AccelSN’ is read as a string (for example from inputdlg), use the str2double function to get it as a number, since the first column of ‘mergetable1’ is apparently numeric.

For example:

mergetable1 = array2table(randi(9, 10, 3))                          % Create Table (To Test Code)
AccelSN = {'4'};                                                    % From ‘inputdlg’
AccelSN = str2double(AccelSN);                                      % Convert To Numeric
BIA0 = mergetable1{AccelSN == mergetable1{:,1},2}
Col_3 = mergetable1{AccelSN == mergetable1{:,1},3}

Please test that with your table and code, since I cannot.

Best Answer

Related Solutions

MATLAB: How to find row position of value in a column

MATLAB: Position and extraction of row

Related Question