Time Stamp Output File with Multiple Tabs Using the Render Tool

[asalgadoponce]

Hi Alteryx Experts,

I am facing an issue and need some guidance on what I'm doing wrong.

All of my workflows follow the same format of the simplified workflow attached to this post (Alteryx Example)...I have data that is then formatted to a table, followed by a title, then, relevant data is joined using 'join multiple' tool for each tab. After that I have a formula for each tab to name the tab and then use the union tool to combine each tab which is then rendered. The output is an excel file with multiple tabs (which is named), containing multiple tables with headers in each table. So far, no issues. 

I was recently asked if the output file can be time stamped. Here's where I'm facing issues. I've tried adding a 'DateTimeStart()' formula and then Modifying Filename by Appending Group to Filename, however, the output file only contains 1 tab. I've tried implementing the time stamp two ways and can't seem to figure out how to work around this.

Alteryx Example Workflow is the file before time stamping it - no issues

Alteryx Example_TimeStamp - Attempt to time stamping output file

Alteryx Example_TimeStamp Method 2 - A second attempt to time stamping the output file

Thank you in advance!

[CoG]

Both Method 1 and Method 2 work on my end (Method 1 would be my first approach too). They both output a single .xlsx file with 2 sheets/tabs. Are you only getting a single output file with one sheet or are you getting one output file per Alteryx section?

This is odd. What version are you running on?

Before I looked at your method 1 and 2 I built out my solution (again it ended up matching your Method 1). This was my configuration for the Render Tool: