Replacing Multiple Filters

[YLYONG]

Hi fellow Alteryx Community,

Am a newbie to Alterxy.

Is there a better way to replace multiple filters with a tool?

Another alternatives is to write formulas.  However for each new formula, I have to introduce a new field or is there a better way to tackle this?

Thank you

[AngelosPachis]

Hi @YLYONG ,

You can use the custom filter option in the configuration window of the filter tool and write a longer expression. The custom filter will allow you to check for more than one conditions and you will then only need a single filter tool

From what I could make from your screenshot, your expression should look something like this

[From DC] IN ("921601","925201") AND [To Location]!=4089 AND [Trsfr Create Date]>="2021-07-22" AND ...

The In function is like using multiple OR statements.

Hope that helps,

Angelos

[YLYONG · Accepted solution]

Thank you @AngelosPachis