Time Stamp Output File that Contains Multiple Tabs

manchokim

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.

Example 1.yxmd

Publish

Workflow

Input

Error Message

Output

Date Time

Preparation

Optimization

Accepted answers

alexnajm

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

All comments

alexnajm

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

binu_acs

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

alexnajm

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

manchokim

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

alexnajm

Did you try my solution then?

manchokim

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703