Limit On-Demand Load When Value is Not Equal To X


I am trying to assist a colleague in limiting a very large data set with via the on-demand settings and need to know if there is a way to limit it when a value is not equal to something.

In the table in question there is a constant string value ("noflag") that is used to identify data that is not necessary for use in capacity determinations. Being able to set an on-demand criteria that only loads data when that field is not equal to "noflag" would provide a considerable boost in performance (eliminates millions of rows of data from being loaded).

I cannot figure out how to limit using a negative criteria (not equal to).  Is there any way to accomplish this?


(1) Answer