How to index into a table with more than 1 variable?

12 views (last 30 days)
Hi,
The current problem i have is trying to index into a table using more than 1 variable. I want to be able to show all rows that have "mark" and "paul" in the name column. Here is an example of what i am trying to do:
table = 20x4 (various data here col 4 = to table.name)
a = {'mark', 'paul'};
idx = table(strcmp(table.name, a), :);
I just receieve and errors that says - "Row index exceeds table dimensions."
This method works if i only use one name in the a paramater. Not sure why it wont for more than one.

Accepted Answer

Stephen23
Stephen23 on 5 Nov 2021
Edited: Stephen23 on 5 Nov 2021
Where T is your table (do NOT use table as a variable name):
out = T(ismember(T.name,a),:);
  1 Comment
MKM
MKM on 5 Nov 2021
cheers, Stephen. Why does this work and the function i used not?

Sign in to comment.

More Answers (0)

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!