Combine multipe excel files

[Hiteshp]

I have three separate Excel files that I need to combine into a single file, with each original file placed on a different sheet within the new file. How can I accomplish this using Alteryx?

[alexnajm]

I don't know how you want to read them in, but it can be as simple as Input Data to Output Data - you just need to use control Containers to ensure the tabs write one after the other: Control Containers: Take Control of Your Workflow - Alteryx Community

[abacon]

@Hiteshp Another option is to follow the instructions in the threads below. You can union the 3 files together if they’re in separate directories after you’ve created a field for each stream that is your desired sheet name, then use the output tool to group the data into each sheet based on the created field. Additionally you can use a macro to read all the files in if they are in the same directory.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Group-output-into-seperate-she...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Rename-Excel-File-Based-on-Cur...

Macro to read data in:

https://community.alteryx.com/t5/Community-Gallery/Dynamic-XLSX-Input-Tool/ta-p/1393832

Bacon