Output Excel workbook with multiple tabs using multiple excel files with different schema

Question

Hi Team, I am just wondering is there anyway I can get the solution where to merge multiple excel files with different schema and the result should be excel book with different tabs based on the sheet name.

Please find the attached sample excel files for the reference.

I tried doing using block until done tool but it is limited to 3 files only.

Package.xlsx

Limitations.xlsx

Workpaper Listing.xlsx

General.xlsx

binu_acs · Answer

@Chhamanshu Once you combined the result using the above batch macro you need to add a formula tool and add a column name Sheet Name and assigned to the file names to that field. Then create a full file path with the output file name and the sheet name column

Batch Macro Template.yxzp

Chhamanshu · Answer

This didn't worked out for me. I worked on another solution and it works for me,

binu_acs · Answer

@Chhamanshu This can be achieved with the help of a batch macro. Please go through the below post

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480