In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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