Filtering rows of a table by giving a constraint to a particular column

1 view (last 30 days)
I have a table lets say, A with 100 rows and 200 columns,
column 150 is 'Alpha',
Now I want to filter this table by applying a contraint to Alpha, lets say Alpha > 100
so my code for filtering is :
Filtereddata = A(A.Alpha > 100);
It shows this error: Subscripting a table using linear indexing (one subscript) or multidimensional indexing (three or more
subscripts) is not supported. Use a row subscript and a variable subscript.
So do I have to use for loop for this, or is there any other method to solve the issue.
Your help is much appreciated.
Thank you.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 17 Oct 2019
FiltereddataofTable = A(A.Alpha > 100,:);

More Answers (0)

Categories

Find more on Statistics and Linear Algebra 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!