I am having trouble configuring a batch macro that will run on multiple tabs/sheets within one Excel file, then move on to the next Excel file and repeat the process, stacking each output after each iterative run, until every file in the folder is read.
A few things to note:
I have the workflow down, just having trouble configuring for my needs. If anyone can upload a workflow that specifically indicates how to configure the interface tools, macro, and directory to run through each Excel tab/sheet until each file in the folder is read, that would be much appreciated!
I've attached sample excel files and my workflow.
Thanks!
I am always using this macro to read the Excels by batch.
The are some empty columns in the file "Illustrative data (structure 3.2).xlsx", which is causing the schema different.
I added a select tool to the workflow deselect extra columns. Hopefully this is work for both data inputs.
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |