Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx Batch Macro Error Handling

xqccc
5 - Atom

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!

2 REPLIES 2
apathetichell
20 - Arcturus

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
21 - Polaris
21 - Polaris
Labels
Top Solution Authors