Combine Tabs into a single worksheet

[hieule1809]

Hi Everyone,

I hope you can help me with the below situation. I have separate tabs in different excel files that need to be combined into one excel files (while remain separated)

So for example, I have Sheet 1 in Excel1.xlsx and Sheet 2 in Excel2.xlsx. Is there anyway that I could create an Excel3.xlsx containing Sheet 1 and Sheet 2 as separated tabs.

Sorry if my demonstration is confusing. Appreciate any inputs! 

[jacob_kahn]

Hey!

Try this link for help https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combine-Multiple-Excel-Workbooks-into-... 

please like and accept if it did help!

J

[grazitti_sapna · Accepted solution]

Hi @hieule1809 , Yes you can collaborate 2 different sheets from different excel into a new one. Here is the screenshot of the result.

You just need to configure your input tool where you an select the sheet for excel.Like this,

In the output tool you need to create an excel file where you can simply change the sheet number such as Sheet1, Sheet2 etc.

Attaching the workflow along for a better understanding. I hope this solves your purpose.

[hieule1809]

Works like a charm! Thank you