How to include multiple filters in Alteryx

[Vicky92]

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.

Account	Entity	amount
233	A	100
233	B	200
258	A	300
258	B	500
258	C	600
233	C	800
233	D	500
233	E	200
258	D	300
300	A	100

[christine_assaad]

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!

[SeanAdams]

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.