Hi, I am trying to combine multiple excels into one where each excel is included in a different tab.
In addition, I need each tab to be named as the name of the Excel file.
I have +100 Excels. Is there a way to facilitate this exercise?
I have already read previous posts but for some reason I cannot re-do the code.
Can anyone integrate these excels in the following form, please?
Input (1):
Input (2):
Input (3):
Output expected:
Thank you.
Hey @selsset97, here's a very simple workflow that achieves this using a macro I built a while ago - https://community.alteryx.com/t5/Community-Gallery/Output-to-multiple-Excel-files-or-sheets/ta-p/951...
Output:
As the inputs share the same schema, we just bring them all in together using a wildcard in the input. As part of the Input Data configuration, we output the filename which is then used as the sheet name in the final output.
The key parts of the aforementioned configuration are here - save the Excels into one directory and use the *.xlsx to bring in every Excel file. Then select 'File Name Only' in option 5:
Hi, thank you for your response. Could you upload the code please?
Hi @selsset97
Sorry seems some error during uploading.
Hope you are able to see the code now.
Many thanks
Shanker V
@selsset97 packaged workflow is attached to my original post which you can download and extract then use :)
I am trying to replicate the code but this error keeps popping up. Do you know how to fix it please? thank you.
@selsset97 there's absolutely no need for a batch macro here because your files all have the same schema. The other two solutions provided should be easier to configure