it does work !
i thought, its not possible to use more expressions in one load.
WHERE( ID_sensor<>'12' OR timestamp<> '02.08.2011') AND
( ID_sensor<>'11' OR timestamp<> '02.08.2011');
It deletes all data from sensors 11 and 12 on date 02.08.2011
this saved a lot of code
the resident load stunt used 70+ lines of code
the trick here is to invert your conditions, just so:
((ID_sensor='12' AND timestamp= '02.08.2011')
OR (ID_sensor='11' AND timestamp= '02.08.2011'));
This can, of course, then be refactored into
WHERE not ( (ID_sensor='11' or ID_sensor='12') AND timestamp=
If you're considering listing lots of sensors to be excluded, consider
replacing " ID_sensor='11' or ID_sensor='12' " with "
And finally, if you're going to want to change the list of sensors on
any regular basis, then avoid changing your code each time by listing
them in a CSV or XLS file, loading them in, and then using a JOIN or
KEEP to filter. But I imagine you'll need further assistance from this
forum if you decide to go down that path.