Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

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

mot
9 - Comet

Hi Karl,

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

AngelosPachis
14 - Magnetar

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

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
13 - Pulsar

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