Replacing Multiple Filters

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

Workflow

Developer

Accepted answers

YLYONG

Thank you @AngelosPachis

All comments

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

Thank you @AngelosPachis

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703