IS NOT EMPTY in a Filter

[Karl_Spratt]

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 solution]

Hi Karl,

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

[AngelosPachis · Accepted solution]

Ηι @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

[danilang]

Hi @Karl_Spratt 

Use ! isemtpy([Warehouse]) or Not isEmpty([WareHouse])  ! is shorthand for not.  There's an equivalent IsNull() function as well.  The difference between them is that a zero length string "" will return true for IsEmpty() but false for IsNull()

Dan

[jrgo · Accepted solution]

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])

[Karl_Spratt]

Thank you all for your help..

That worked.. 

Again Thanks,

Cheers,

Karl.