Combine multiple workbooks into one

Hello - I am looking to find a way to combine multiple excel workbooks with different sheet names into one workbook. As an example Workbook 1 containing Sheet 1 and Sheet 3 to combine with Workbook 2 containing Sheet 34 and Sheet 56. The combined workbook would be containing Sheet 1, Sheet 3, Sheet 34 and Sheet 56 unchanged from original format. Thank you!

Workflow

Accepted answers

All comments

Qiu

@geax
This is in my collection for this kind of problem.

Multi Sheet Import Example 2.yxzp

geax

Hello,

Thank you for posting your solution. When I open I see the following message. What steps do I need to take next?

Thanks again!

Luke_C

Hi @geax - click import. A yxzp file is just an alteryx zip file containing the workflow and any supporting files/macros.

geax

Thank you for the response. I do received the following message. How do I go about it?

Luke_C

@geax Click OK. Wherever you downloaded the file to there should be a folder with the same name as the yxzp. Within that you will find the workflow and should be able to open (You will receive a similar warning, but it should be okay). Alternatively, in that file you can open the yxmd and yxmc files in a text editor and update the version to match yours (will be on the first few lines).

atcodedog05

Hi @geax

You can use this guide to downgrade

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps : )

geax

I am getting error opening the notepad:

Luke_C

Hi @geax - you are opening the yxzp file in notepad. Navigate to the folder that was created and open the yxmd and yxmc files. Alternatively opening those files should just give you a warning you can click through.

TheOC

hey @geax

in the screenshot you are trying to open the yxzp in notepad. Follow the guide @atcodedog05 sent closely - you need to open the workflow files (yxmd/yxwz) that are within the folder that should be created after trying to open the yxzp.