IS NOT EMPTY in a Filter

Question

Hi Community,

How do I write into a Filter IS NOT EMPTY  or IS NOT NULL

I can see the IsEmpty, or the IsNull

See below, simple Filter but I want to add is a 3 part to show only the orders with a Hold Category for this customer, on this Warehouse.

TIA,

Karl.

mot · Accepted Answer

Hi Karl,

If you add ! in front of it, it should work (!IsNull etc.). I hope this helps. Best.

AngelosPachis · Accepted Answer

Ηι @Karl_Spratt ,

In Alteryx, NOT has an exclamation mark as a symbol, so IS NOT NULL OR IS NOT EMPTY would be

!ISNULL()

!ISEMPTY()

Hope that helps,

Angelos

jrgo · Accepted Answer

HI @Karl_Spratt

Below is the expression that I think would work. ISEMPTY() qualifies both NULL and Empty values so no need to specify both in an OR statement.

[WAREHOUSE] = 'UCV'
AND [CUSTOMER NUMBER] = '306678'
AND !ISEMPTY([HOLD CATEGORY])