Run Batch Macro for Multiple Sheets per Excel File

Question

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:

* Each sheet/tab has the same structure
* Each Excel file has the same tab names (and same structure)
* The output for every run should have the same columns

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!

Illustrative data (structure 3).xlsx

Illustrative data (structure 3.2).xlsx

Illustrative (Structure 3).yxmd

shelbybradley · Answer

@gabrielvilella

@Qiu

I added a select tool to the workflow deselect extra columns. Hopefully this is work for both data inputs.

Illustrative (Structure 3).yxmd

Qiu · Answer

@shelbybradley

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.

Multi Sheet Import Example 2-r1.yxzp

gabrielvilella · Answer

Your sheets do not match the same schema, just tried that in Alteryx. I recommend you use a combination of two macros as the workflow attached.

XLSX reader.yxzp