community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Output to multiple Excel tabs and create new file each run

Atom

Does anybody know how to output multiple Excel tabs and create new file (with new name) each time the workflow is run? I can do them separately (output a file with multiple tabs OR create a new file with new name, for example date stamp) but not together. Is there a way to select both Change File/Table Name and Change Entire File Path at the same time? The menu will only let me pick one at a time

Capture.PNG

Highlighted
Alteryx Certified Partner

If I understand your aim correctly "Change Entire File Path" should be able to accomplish both a new file name and new sheet names as long as you build up the entire syntax in a single field.

 

See attached workflow.

Atom

Perfect. Thank you very much!

Labels