Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
18 - Pollux
18 - Pollux

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

alexnajm
18 - Pollux
18 - Pollux

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