Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

IS NOT EMPTY in a Filter

Karl_Spratt
8 - Asteroid

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. 

Capture.PNG

5 REPLIES 5
mot
11 - Bolide

Hi Karl,

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

AngelosPachis
16 - Nebula

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

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
14 - Magnetar

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
8 - Asteroid

Thank you all for your help..

That worked.. 

Again Thanks,

Cheers,

Karl. 

Labels