Output In different tabs - need to update every Single run.

Question

Hi,

Could you please assist me on below issue (using 2019 version).

I need to create multiple sheets by using field name (Team), output option as a overwrite file(Remove) - Screenshot attached.

- if i opt for overwrite sheet (drop) - in case no information in a particular tab it was not replaced with the old tab content, still it showing old information for me.

- so i want to create new file with multiple tabs for every single run - Thanks in advance.

DataNath · Answer

Thanks for clarifying @Jaganmohan!

I recently built a macro that will do this for you. If you download it here: https://community.alteryx.com/t5/Public-Community-Gallery/Output-to-multiple-Excel-files-or-sheets/ta-p/951995

You can then insert it into your workflow by right-clicking on the canvas > Insert > Macro and navigating to wherever you saved it.

Plug your data stream into the input and configure it using the ‘Multiple sheets’ option! If you run into any issues let me know.

Jaganmohan · Answer

Hi @DataNath,

thanks, i want to create a new file each time with multiple tabs.

Jay-RDC · Answer

You might need to create a batch macro for that so that you can dynamically update the sheet name by updating "|||Sheetname" in the filepath.