Free Trial

Alteryx Designer Desktop Discussions

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

Time Stamp Output File that Contains Multiple Tabs

manchokim
6 - Meteoroid

Is it possible to timestamp an output file that contains multiple tabs?

I have workflow that creates multiple tabs based on the result of the join function.

I then try to pass a formula to overwrite the Entire File Path with a timestamp but it results in an error.

Attached is an example of the workflow.

 

6 REPLIES 6
alexnajm
17 - Castor
17 - Castor

Use DateTimeStart to be safe - DateTimeNow could result in slightly different timestamps

 

Otherwise use Control Container to ensure one tab finishes before the next one starts

Time Stamp Output File that Contains Multiple Tabs.png

binuacs
21 - Polaris

@manchokim Do you want one excel output file with different tabs or 3 different excel output file with 1 tab each?

alexnajm
17 - Castor
17 - Castor

Based on the workflow, one excel output file with different tabs I assume

manchokim
6 - Meteoroid

It would be one excel output file with 3 different tabs.

alexnajm
17 - Castor
17 - Castor

Did you try my solution then?

manchokim
6 - Meteoroid

Sorry for the delay in responding, we were going through an update from Alteryx 2022 to Alteryx 2024 so I did not have Control Container tool at the time but can confirm now that this solution works.

Labels
Top Solution Authors