Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to include multiple filters in Alteryx

Vicky92
7 - Meteor

Team,

 

Is their any way to include multiple filters in the data & get desired result. E.g. if Account & entity combination is

 

A. 233 (Account) & A (Entity) then amount should be updated. Rest every combination with 233 account & other entity should not be reported.

 

B 258 (Account) & B (Entity) then amount should be updated. Rest every combination with 258 account & other entity should not be reported.

 

I need to use both the combination of condition in data set.

 

AccountEntityamount
233A100
233B200
258A300
258B500
258C600
233C800
233D500
233E200
258D300
300A100

 

2 REPLIES 2

Hi @Vicky92 

 

Please check the below options. You can use a formula to build the logic followed by a filter OR a filter directly, as below. Hope this helps. Cheers!

 

christine_assaad_0-1613749778119.png

christine_assaad_0-1613749939856.png

 

 

SeanAdams
17 - Castor
17 - Castor

hey @Vicky92 

 

@christine_assaad 's solution gives you 2 ways to do this elegantly.

A third way is to drop 2 filter tools on your canvas connected to the input - each filter just takes care of 1 of the rules.

You then use a Union tool to stack the results back together.

 

The choice of which way to solve this sometimes depends on thinking about the person who has to maintain this canvas once you've moved on to your next project / job - so if you can make canvasses as easy / obvious to read, then they become much easier to hand-over and maintain.

 

 

Labels