Start Free Trial

Alteryx Designer Desktop Discussions

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

filter formula

chiragpatel_1
8 - Asteroid

I have filter below which contains formula to take forward data for the groups I have defined in there, however i only want to take forward certain groups for a the  two specific accounts defined in the formula below.

 

Although the formula gives me no error, all the output processed goes to false anchor.

 

What amendments do I need to make?

chiragpatel_1_0-1646302853695.png

 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@chiragpatel_1 
You are using a Condition statement for the then and else part, so it will return a Bolean value, which is true or false.

Qiu
21 - Polaris
21 - Polaris

@chiragpatel_1 
Maybe some like this?

([account] = "V40823" or [account] = "V17312") and Group in ("GT","PS","GP","PT")

 

chiragpatel_1
8 - Asteroid

what would i add to that fro rest of the other accounts?

something like this?

chiragpatel_1_0-1646303757424.png

 

Qiu
21 - Polaris
21 - Polaris

@chiragpatel_1 
The rest of other accounts will go to the "F" anchor.

Qiu_0-1646304278079.png

 

Labels
Top Solution Authors