Alteryx Designer Desktop Discussions

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

Filter

chiragpatel_1
8 - Asteroid

Quick query - I have the following statement in snippet below for two specific account but for all other accounts I want the following  condition to apply [Group 2] in ("GT","PS","GP","PT", "UM", "MC"), how would i go about adding that

 

chiragpatel_1_0-1646392341291.png

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @chiragpatel_1 

 

Here is how you can do it.

Workflow:

([Account] in ('V40823','V17312') and  [Group 2] in ("GT","PS","GP","PT")) 
OR
([Account] not in ('V40823','V17312') and  [Group 2] in  ("GT","PS","GP","PT", "UM", "MC")) 

 

Hope this helps : )

chiragpatel_1
8 - Asteroid

Thank you for the below, just to clarify, will this bit chose any one of those account it can find?, I would like the first condition to apply to both those accounts, sorry should've clarified originally 

([Account] in ('V40823','V17312')

 

atcodedog05
22 - Nova
22 - Nova

Hi @chiragpatel_1 

 

Yes, it works for both accounts.

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @chiragpatel_1 

Cheers and have a nice day!

Labels