Multiple excel output file into one output file with multiple sheets

[akvsachin]

In an Alteryx workflow, we have 9 separate containers that generate the same output file (Firm.xlsx) but with different sheet names (A to I). Each container writes its own sheet to the file, resulting in multiple instances of the same file being overwritten.

Requirement: We need a single Firm.xlsx file that consolidates all sheets (A to I) into one final output file, ensuring that no data is lost due to overwriting.

[DavidSkaife]

Hi @akvsachin 

Change the Output Option on the Output Data tool to 'Overwrite Sheet or Range'

[akvsachin]

Hi @DavidSkaife ,

Attached an image of multiple containers

Elaborating my requirement:

Container 1: Output FileName:- Firm.xlsx, Sheet Name :- A
Container 2: Output FileName:- Firm.xlsx, Sheet Name :- B
Container 3: Output FileName:- Firm.xlsx, Sheet Name :- C
Container 4: Output FileName:- Firm.xlsx, Sheet Name :- D
Container 5: Output FileName:- Firm.xlsx, Sheet Name :- E
Container 6: Output FileName:- Firm.xlsx, Sheet Name :- F
Container 7: Output FileName:- Firm.xlsx, Sheet Name :- G
Container 8: Output FileName:- Firm.xlsx, Sheet Name :- H
Container 9: Output FileName:- Firm.xlsx, Sheet Name :- I

Now I need one output file.
New container: Output FileName :- Firm.xlsx, Sheets:- A, B, C, D, E, F, G, H, I

Ensuring no data is lost. because in this way the other processes are getting terminated as 1 file is generated.

 

[binuacs]

@akvsachin try the below approach, this will make sure that first create the Film.xlsx with the Tab named A, then B, then C etc