How to include multiple filters in Alteryx

Question

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.

AccountEntityamount233A100233B200258A300258B500258C600233C800233D500233E200258D300300A100

Alteryx Issue.xlsx

SeanAdams · Answer

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.

Christine_Assaad · Answer

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!