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 · Accepted 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

[knozawa]

@patrick_digan,

Thank you for your answer! This is very helpful.

Sincerely,

Kazumi