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