Alteryx Designer Desktop Discussions

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

Multiple not contains in one filter tool

nickrosen28
7 - Meteor

Hi everyone,

 

I am trying to pull in all rows that contain [Airline/Parter Name] that aren't these codes 

 

AS , AT, BA , CZ , ET , QF , KE , KX , EI , LH , MH

 

This formula is giving me a "Error: Filter (34): Parse Error at char(33): Unknown variable "AS""

 

Why is that and how can i fix this formula below

 

[Airline / Partner Name] NOT IN (AS , AT, BA , CZ , ET , QF , KE , KX , EI , LH , MH)

 

Thanks!

 

1 REPLY 1
nagakavyasri
12 - Quasar

Use quotes for strings:

 

Screenshot 2023-06-27 132555.png

Labels