Alteryx Designer Desktop Discussions

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

Custom Filter trying to filter for 2 criteria

sderby
5 - Atom

I am trying to filter a specific column for two parameters rather than one. The logic string I am trying is :

 

IF [Functional Area] = "XYZ" OR [Functional Area] = "ABC"

 

I want to filter the data set down to include just XYZ and ABC but am struggling with writing the logic string. 

3 REPLIES 3
alexnajm
17 - Castor
17 - Castor

You don't need the IF part! Just: 

[Functional Area] = "XYZ" OR [Functional Area] = "ABC"

sderby
5 - Atom

Thank you! Easier than I thought 😁 I noticed it worked for me without quotation marks around the Functional area codes... does it matter if they are used or not?

alexnajm
17 - Castor
17 - Castor

I would leave them!

Labels