Merging multiple .xlsx workbook into single Excel workbook

[Vishal_95]

Hi,

I was trying to merge multiple .xlsx workbook with different format into single Excel workbook (with each excel file as separate sheet) without making changes to there format. Any suggestion on how I can achieve the above goal.

Note: The output's were generated using the multiple Render tools

[ChrisTX]

See this knowledge base article:

The Ultimate Input Data Flowchart
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

After you bring in the different formats, you can use the Output tool to create separate sheets in one output file. 

See this article:

Output to multiple sheets within an Excel file
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Output-to-multiple-sheets-within-an...

and the tool mastery article:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Output-Data/ta-p/30023

Chris

[Vishal_95]

Hi @ChrisTX 

Thank you for the suggestion. As per the article the output get's combined into a single sheet & the format of the file is lost, where as I am trying to combine each of the workbook into a separate sheet in the final output.

[Luke_C]

Hi @Vishal_95 

You note that the sheets were created via multiple render tools. What is the reason for trying to combine the excel files rather than modifying your workflow to render them all together? 

[Vishal_95]

Hi @Luke_C 

Sorry for confusion, currently the output generated are mix from multiple Macro Output & Render tool.  

[Luke_C]

@Vishal_95 I think my question still remains, if all of the data is already in your workflow I would think it's easiest to consolidate it there into a new output rather than make a new process to read in multiple excel files. The formatting is the tricky thing here. You could definitely use one of the approaches @ChrisTX mentioned, but you'd have to make a new render tool to control the format or output to a custom template depending on what this formatting is.