Batch macro to loop through list of conditions

stephen787

hello everyone,

I'm trying to build a workflow to loop through a list of conditions and categorize my data by adding a column to the new data.

I can achieve this using a formula but I would like to use a batch macro if possible instead with input from a list of conditions. I have attached a list of sample conditions.

For example if field JC = a AND A = b AND JN contains c AND LD contains d then categorize as "Blue".

Could this be achieved using a batch macro? Does anyone have an example of how the workflow would look like?

Thanks!

Conditions.xlsx

AmrMansour

Hi @stephen787 ,

Love the second solution possibility that you are looking for. As we all know, one answer can be done with multiple solution workflow. 

Anyway, for the Batch Macro, I believe that one of the solutions could be a join between the Database and the conditions table. for each record from the database, the Join tool will find the right category in the condition table. 

PS. for the partial match you can use the Find Replace tool 

Does that make sense?

Cheers

Amr