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
Solved! Go to Solution.
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
Thank you @AngelosPachis