Filter by AND/OR

knozawa

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

patrick_digan

@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