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

[Chhamanshu]

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.

[binuacs]

@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/t...

[Chhamanshu]

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

[binuacs]

@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