Get Output to multiple tabs from Different Input files

Question

Hi All,

Is there a way I can Open multiple input files all at once, such that after (example) sanitizing/formulating it, can give output to multiple tabs in the same output file?

I have attached the two Sources from where I want to get the output in two tabs of the Main Template.

If anyone can please help me to understand how is that done, it would be great! :)

Source.xlsx

Source 2.xlsx

Main Template.xlsx

damalraj22 · Answer

Hi db89,

Got it sorry about the confusion. Seems like you will need to create a macro or use the union tool to do this. Also to read all the files in one tool you can use the Dynamic Input tool as well. Take a look at this community page below and let me know if this helps.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-files-with-multiple-sheets-into-one-file-with-multiple/td-p/723634

db89 · Answer

Hi @damalraj22,

Yes that I have tried, but my objective is to just get the result from multiple input files stored in a single folder and getting the output in multiple tabs (with only one output tool) of the prescribed template.

db89 · Answer

Hi @ShankerV,

No worries but appreciate for the reply!

For example, from the multiple inputs (Source and Source 2 files) I want to paste in Sheet 1 and Sheet 2 tabs of the 'Main Template' file.

The objective is to just get the result from multiple input files stored in a single folder and getting the output in multiple tabs of the prescribed template.