In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output Data to Multiple Excel Sheets with Timestamp File Naming

geeklarokcmie
8 - Asteroid

How can I configure Alteryx to output data into two different sheets within the same Excel workbook and save a new file with a unique timestamp - each time the workflow runs?

I built an example workflow and the file is only being saved as one sheet instead of two. I'd appreciate if someone can help.

 

Thanks.

3 REPLIES 3
alexnajm
19 - Altair
19 - Altair

Change your Output Option to "Overwrite Sheet", not "Overwrite File"!

alexnajm
19 - Altair
19 - Altair

For the dynamic file name, check out this article: How to: Dynamically rename output files. You can adjust the datetime function to your need - however, it looks like you have that part already in your workflow

geeklarokcmie
8 - Asteroid

Thank you :)

Labels
Top Solution Authors