In scripting, I need to know the syntax to delete items where a cell value is not equal to a specified value. For example:
In the screen shot I want to loop through each “Use” entry and remove from Matrix 1 via a script the items in category B that have a “Use” not equal to “YES”.
if (!|Matrix1|.getSelection(it, |Matrix1::Use|).value.equals(“YES”))
Thanks to the IDBS Support desk on this one. As a note the exclamation point “!” in the “if” function is “not equals”. If you wanted to removed all “YES” items instead then simply remove the “!” from the “if” function.