I have a very silly and simple question. I am filtering some column in preceding load.
My requirement is : Financial Responsible Indicator is equal to / is Y, AND Paid Claim Indicator is equal Y, AND NIA Financial Flag is equal N, AND Funding Arrangement Description is equal to NOT APPLICABLE , FULLY FUNDED PLAN
so I filter out with these code:
WHERE [Financial Responsible Indicator]= 'Y' OR [Paid Claim Indicator]= 'Y' OR [NIA Financial Flag]='N' OR [Funding Arrangement Description]= 'Fully-Funded ' OR [Funding Arrangement Description]= ' Not Applicable ';
But It is not filtering out Properly and when I am doing with AND I am not getting any value. Please suggest.
If all the conditions must be met then you should use AND instead of OR.
But 'NOT APPLICABLE' is not the same as 'Not Applicable '. Those two values are two different values because the first in completely upper case and also because it does not contain a trailing space. Make sure to use the exact case sensitive values that should be used to compare the field values with.