different outputs in the same excel file

[FernandoR]

Hello community, good day, could someone help me know how, when generating the output in Excel format in an Alteryx flow, I could create more outputs but instead of creating more Excel files, they would be added to the same excel but creating different sheets with different names, since when I want to do it that way I get an error that the file is already open.

 I attach an image of the configuration that I currently have in the excel output.

Thank you very much for the support

[OTrieger]

@FernandoR 

What you will need to do to change the sheet names in your full path, so that will ensure that all the sheets will be saved on the same file.

You can do it in a batch macro then you will not have an issue, or split the data and use Parallel Block Until Done or Control Containers all these ways will ensure that the sheets will be saved on different intervals.

[FernandoR]

Thank you very much for the comment, but do you happen to have a small flow as an example, even if it is 2 sheets that are saved in the same Excel? To give me a more precise idea and be able to replicate it in my flow?

[binuacs]

@FernandoR one way of doing this