Iterative Macro - Rerun whole data set

AbigailShaw

Hi all, 

I was wondering if it possible to rerun a workflow with all the original input data depending on a condition using an iterative macro.

In my workflow I run a check to see if the pair of employees matched together have the same manager using a formula tool. This creates a new column called 'Manager Check' which says 'OK' if the pair don't have the same manager or 'ERROR' if the pair do have the same manager. 

I know you can filter the 'Manager Check' column and send the data with 'ERROR' back through the workflow however I am wondering if there is a way to send all the results back through the whole workflow if there are any results containing 'ERROR' in the Manager Check column?

I hope this makes sense!

Thanks,

Abby

Pilsner

Hello @AbigailShaw 

It sounds like you are trying to impose a conditional statement on the whole table instead of just the individual records. I have attempted to solve this using the following method:

1) Use the formula tool to create a "Manger Check" column. If two people share the same manager the get marked with "Error" in this column.

2) Filter to all records where the "Manager Check" column equals "Error", the count how many there are.

3) Append this count back to every record in the table.

4) If the count equals 0 then all the records will be filtered out of the true anchor towards the main Output. 

If the count doesn't equal 0 (i.e one or more pair share a manager) then all the records will be filtered out of the false anchor towards the Loop output.

5) The select tools are simply to drop the Manager check and Count column.

Please find the macro attached below.

I hope the above all makes sense but I'm happy to expand further if needed. Please let me know how you get on.

Regards - Pilsner

Itterative Macro - Rerun if one or more pair have the same manager.yxmc