Alteryx Batch Macro Error Handling

[xqccc]

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!

[apathetichell]

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.

[Qiu]

@xqccc 
Similar with approach of @apathetichell 

We have a macro here and it is very useful.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from...

[xqccc]

First of all, thanks for your reply! 

Yes, that's actually what I have been doing previously, setup some validations before the macro to make sure all the data being passed to macro are valid ones that won't cause any error for the macro. 

I am just curious if there is some kind of setting or configuration to automatically skip the files that causes errors. Because sometimes we can't think of all the possible errors that user might encounter during the building process. 

[xqccc]

Thanks for your reply! 

I am just curious if there is some kind of setting or configuration to automatically skip the files that causes errors. Because sometimes we can't think of all the possible errors that user might encounter during the building process.