Importing and Editing multiple reports

Cferrer6

Hi all, 

I am sort of new to Alteryx and i am wondering if there is a way to import multiple excel reports and do the following to them all, all together without having to import one at a time and run it each time?

Import 50 excels reports and complete the same steps each time

Copy information from tab 1 and insert it in the first few lines of tab 2

Delete tab 1

rename the tab we didn't delete. 

Attached is a raw copy of the file and a edited version of what i need the file to look like after

Updated.xlsx

Raw.xlsx

MattBSlalom

This sounds like a prime opportunity to build a batch macro!  The macro will handle the activities you'd perform against a single file, and it will be called by a parent workflow that passes in the list of files to take action on.  Since your sheets have totally different field lists that you're trying to combine, the Reporting tools are how to link them together.  Rather than explicitly trying to "delete" or "rename" tabs in your files, we can just overwrite the whole file with the single desired tab.

Simple parent workflow to gather file names and pass into batch macro:

Batch macro to process 1 file at a time:

ProcessExcelReports.yxmd

MergeExcelReportSheets.yxmc