Alteryx Designer Desktop Discussions

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

AND Not in a Single Custom Filter

Inactive User
Not applicable

 

Hi,

 

I am working on extracting the Vendor names that not already in my list so I can add them into my database.

 

So filter condition should be:

 

Vendor Name (Amended) = NULL

AND

(Vendor Name Should not be 0 AND Vendor Name Should not be 'Unavailable' AND Vendor Name Should not be Blank)

 

For some reason, below filter condition is not working and I am getting a parse error. Please advise.

 

PKoya1_0-1600276219480.png

 

1 REPLY 1
vizAlter
12 - Quasar

Hi @Inactive User â€” Looks that [Vendor Name] field has string data type, so write "0" instead of just 0

Labels
Top Solution Authors