How to filter out '0' values from two fields, when both fields have '0' in adjacent rows?

[dominicmazvimavi]

Hi everyone!

In my script, I would like to filter out 0 values from fields DMV and CMV, only at a instance when both fields have the value 0 in their rows. 

Thank you 

[MayilVahanan]

Hi

Try like below

Load * from ursource where DMV+CMV <> 0;

Hope DMV & CMV doesn't have negative values. If have, 
Load * from ursource where DMV<> 0 and CMV <> 0;

[dominicmazvimavi]

Hi Mayil
Thank you for your response.  

Yes, I do have negative values and yes, I  tried the script which you suggested if I do have negative values. 
The problem with that script is that any instance DMV or CMV have a 0 value, the rows are filtered out and not ONLY when BOTH CMV and DMV have 0 values. 

Any other suggestions?