This content has been marked as final. Show 3 replies
I'm assuming you are using Informatica.
and then use variance>0
Correct syntax issues if required
If helps pls mark
Edited by: Srini VEERAVALLI on Dec 3, 2012 7:31 AM
Thanks for your reply.
Cant I just this condition variance!=0 or variance=0 and just ignore (variance) from the condition.
My aim is to filter the zero values and non-zero values.
I dont think variance!=0 or variance=0 is correct.
telling !=0 and same time =0
try to follow as said and see how it works