if any command to check table values

42 views (last 30 days)
Ilyass Boukhari
Ilyass Boukhari on 17 Jan 2021
Edited: dpb on 17 Jan 2021
I have a problem in checking if a table contains at least one value above a set limit.
I am using this short code
if any(Y>Threshold) %conditions
disp('ExtinguishMode ON')
else disp('ExtinguishMode OFF')
end
Even though when checking the Y variable table there are numbers above the threshold (which is 100), the command still displays the opposite condition 'ExtinguishMode OFF'. I am attaching here a screenshot
What am I doing wrong?

Accepted Answer

Adam Danz
Adam Danz on 17 Jan 2021
Edited: Adam Danz on 17 Jan 2021
Assuming Y is a matrix,
if any(Y>Threshold,'all')
Conditional statements expect to recieve a scalar value. Your syntax was providing a vector and if any values of the vector are false, the condition will be false.

More Answers (1)

dpb
dpb on 17 Jan 2021
Edited: dpb on 17 Jan 2021
We don't have the data and can't see the actual result in context -- although the code snippet posted isn't formatted well, that doesn't affect the outcome;
if any(Y>Threshold) %conditions
disp('ExtinguishMode ON')
else disp('ExtinguishMode OFF')
end
is the same as
if any(Y>Threshold) %conditions
disp('ExtinguishMode ON')
else
disp('ExtinguishMode OFF')
end
BUT, the problem is that if() is TRUE iff all elements of the result are TRUE but since Y is a 2D array, the logical expression any(Y>Threshold) is a row vector of the conditions by column. Apparently there is at least one column for which the threshold is not exceeded.
You're looking for the optional 'all' flag to any here...
if any(Y>Threshold,'all')
If that is not recognized in your release (not sure when that syntax was introduced), then use
if any(Y>Threshold(:)) % check all of Threshold as vector
or
if any(any(Y>Threshold)) % check all of Threshold by checking vector returned by any

Categories

Find more on Tables 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!