if any command to check table values

42 vues (au cours des 30 derniers jours)
Ilyass Boukhari
Ilyass Boukhari le 17 Jan 2021
Modifié(e) : dpb le 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?

Réponse acceptée

Adam Danz
Adam Danz le 17 Jan 2021
Modifié(e) : Adam Danz le 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.
  1 commentaire
Ilyass Boukhari
Ilyass Boukhari le 17 Jan 2021
Thank you, that worked

Connectez-vous pour commenter.

Plus de réponses (1)

dpb
dpb le 17 Jan 2021
Modifié(e) : dpb le 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

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by