Combine Multiple excel worksheets in 1 excel file with another as separate tabs

Hello,

I need some guidance around a workflow am working on where in I have 2 excel output files with multiple sheets and I need to merge it with excel file as separate tabs. However, the final output filename contains wildcard. Can someone please assist on how can I achieve this

Regards

Mustafa

Input

Output

Accepted answers

All comments

clmc9601

Hi Mustafa @D142627,

So each of your output tools is writing multiple xlsx files? Are you already using the "Select Take File/Table Name From Field" option? By using this option, you can tell each output tool to write to multiple tabs on the same file, multiple files with the same tab, or multiple files with different tabs. Heads up that the "Change File/Table Name" setting on xlsx output only changes the TAB name, not the workbook name.

D142627

Hello Claire @clmc9601 ,

Thank you for your guidance. So basically the original requirement was to write the output in the input file itself since it creates around 7 worksheets. One point to note is the Input file name is not static - meaning every month the input file is prefixed with date time stamp. Hence I have used a wildcard to pull the file in Alteryx. However, when I use a wildcard to open the same input file and save the resulting output from the workflow into multiple sheets, it gives me an error 'Error opening file: *abc.xlsx'. Due to this I had to create a new output file with a static name to save these 7 sheets within that. Now am trying to merge the input file which already has 15 worksheets and the new output file with 7 worksheets. I have attached a snapshot of the error which I recreated using dummy data when I try to use wildcard in the output tool.

Is there a better way of doing it?

Regards

Mustafa

Error snapshot.png

mceleavey

Hi @D142627 ,

can you provide some mock data to show what you're trying to do?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703