Batch Macro error handling

[ValM]

I have a batch macro that makes calculations on a set of 3 fields. The trios are fed into the macro, macro calculates and logs results for each set of 3, one under the other.

The problem is that my set of fields sometimes are incomplete, instead of feeding the macro the 3 fields, only feeds 2, or 1. In this case I would like the macro to ignore that set and continue with the rest.

As of now, these errors means that the macro doesn't give any output.

I looked into detours, but it don't know how to feed the route to the detour.

I tried a filter, which is what I put in the sample workflow, but makes no difference.

I am attaching a small work flow with sample of data and the  part of the macro that would need to have the error handler.

Any suggestion will be greatly appreciated!!!!

Thank you!

[gabrielvilella · Accepted solution]

The only way to control the detour is if the information comes from outside the macro. There are two ways to achieve this. One is having a step outside your current macro that will open all files and then you will have a table with all the file names and what fields do they have. Another option is to build a second macro and place it inside your existing macro, this containing a step that will check the field names and the second one with the detour.

[ValM]

@gabrielvilella  Thank you so much for your help. I actually learned a few of things from this post! I will implement one of those two ideas, although a macro inside a macro will be a new adventure for me :) THANKS!!!