This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm looking to pull the same tab from many .xlsb files from a same directory, perform the same cleansing steps on the data from each file and combined all of the cleansed data. Batch Macros seem like they should be able to handle this, but when I try to run my workflow, which has a directory tool feeding a fullpath into a batch macro, I receive a 'File Must be Specified' error. My Macro consists of an input, update value with the file name selected, and input data tool, and then my data cleansing steps that apply to each file, before a final output tool. Any guidance on what may be causing this issue?
A batch macro can certainly handle your use case. Another option that might work that does not require a batch macro is the Dynamic Input tool . As long as each of the sheets have the same schema the Dynamic Input tool should do the trick allowing you to make all the edits at once. I have attached an example workflow (2018.4) that shows how this can be done. Hope this helps!
It's actually kind of hard to share this file while providing sample data, but I was able to resolve the issue.
One simple thing that was throwing me off when working with macros is that you may update the macro, but if you try to run a workflow referencing the macro before you save your updates, the workflow won't see them. Remember to save your macro before running another workflow that references it!