Loop through multiple conditions

CodingMan

Hi Guys,

I am trying to filter a data set based on multiple conditions. This is how the data looks like

I have 3 conditions:

1. If customer ID = 1 AND Order $ is multiple of 5 and less or equal to 40

2. If customer ID = 2 AND Order $ is multiple of 5 and less or equal to 60

3. If customer ID = 4 AND Order $ is 7 or -7

I know I can create 3 branches using filter tool. But I will have more conditions in the future (around 100) I don't wanna have 200 filter tools in my workflow.

Is there a way to filter the data condition by condition (use as less tools as possible) and put all data that meet requirements into one table?

Any thoughts will be appreciated.

jdunkerley79

You can do this using a Batch macro to evaluate each condition as a formula against the input data.

I've attached a sample workflow to get you started.

Dynamic Batch Condition.yxzp