Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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?