Hi,
I have a question about the Alteryx batch macro error handling process. Assuming I have a bunch of files and a batch macro to extract data from one of the tabs of those files. However, one of the files doesn't have that tab in the file. When I try to run the batch macro, it will give an error, and the macro will not return any data. Is there a way to let the macro skip the file that has error and run through the rest of the files?
I have been building check and validation process before the macro. But it would be great that the macro can skip the files have errors, process files that have no issues and output the data from those files. Thanks!
May I recommend the nested batch macro approach --- macro 1 ) --- list of sheet names. macro 2--- reads in the sheet. throw a filter in macro 1 to prevent processing if the sheet name is not present.
@xqccc
Similar with approach of @apathetichell
We have a macro here and it is very useful.

