Multiple files into one file with multiple sheets

[DiattaF]

Hello, 

I was wondering if there is a way I could generate a file with multiple tabs from multiple inputs.

Any help would be greatly appreciated.

Thanks, 

DiattaF

[Carlithian]

You can use the 'Take File / Table Name From Field' option on the output tool. 

Personally I like to make the filepath in a formula tool and use the 'Change Entire Path' setting and point to that field you created. 

The format for an excel filepath is:

FolderStructure\Filename.xlsx|||sheetname 

it is the sheet name that you will be changing 

there are good examples on this thread - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Generate-output-file-with-mult...

[DiattaF]

Thank you for your time, much appreciate it.

Do you mind showing me a step by step on how you would take multiple inputs into one single file with differents tab.

exple: Input 01, input 02, input 03 ===>1 file output file (Tab 01, Tab 02, Tab 03)

Thanks again for your time,

DiattaF

[binuacs]

@DiattaF in each input file how many sheets are present? Single sheet or multiple sheets? you can use the batch macro for this

[DiattaF]

Each input sheet has 1 sheet in it. 

if I have to use a macro what would be the step by steps?

Thanks again for your time.

[DiattaF · Accepted solution]

I figured it out without macro, and it was pretty easy. 

Thank you all!!