Hello,
I was testing filter tool using AND/OR.
This is the original input:
Here are output using 4 different filters:
1) IsNull([Field1]) AND IsEmpty([Field1]) --> only take into account the first expression, 'IsNull([Field1])'
2) !IsNull([Field1]) AND !IsEmpty([Field1]) --> desired output.
3)IsNull([Field1]) OR IsEmpty([Field1]) --> desired output
4) !IsNull([Field1]) OR !IsEmpty([Field1]) --> take into account only the first expression '!IsNull([Field1])'
Does anyone know the reason why negative expression will flip the logic of AND/OR?
Sincerely,
Kazumi
Solved! Go to Solution.
@knozawa great question! Isempty will actually return true for empty and null cells. If you try isempty, your should have two true records.
Edit: here is the help info: https://help.alteryx.com/11.8/index.htm#Reference/Functions.htm?Highlight=Isempty