Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

filter

chiragpatel_1
8 - Asteroid

Hi,

 

I have this statement in my filter and the problem is that everything is going to false anchor instead of true, what else do i need in that statement so that all those appear into true anchor, is it and or?

 

chiragpatel_1_0-1646054517767.png

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @chiragpatel_1 

 

Try below formula in filter

 

[Group 2] in ("GT","PS","MC","UM","GP","PT")

 

Workflow:

atcodedog05_0-1646054809721.png

 

Hope this helps : )

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @chiragpatel_1 ,

 

you should use

[Group 2] IN ("GT", "PS", "MC", ...)

 

([Group 2] = "GT" OR [Group 2] = "PS" OR ... is also possible)

 

This chercks, if the value of [Group 2] is one of the entries in the brackets after "IN".

 

Let me know if it works for you.

 

Best,

 

Roland  

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @chiragpatel_1 

Cheers and have a nice day!

chiragpatel_1
8 - Asteroid

thank you again @atcodedog05 !

 

@RolandSchubert thank you, il keep your second solution in mind

Labels
Top Solution Authors