Alteryx Designer Desktop Discussions

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

Adding a time constant to several branches in a workflow

leonhekkert
8 - Asteroid

I have a workflow that has a lot of branches. All these branches write to the same excel, but in different tabs. 

The name of the excel file consists of the date but I would like to add the time as well.

 

How can I add the time to the end of each branch but calculate it at the beginning of the workflow? If I calculate it at the end of each branch then the time could differ between branches.

 

I'd rather not calculate it at the beginning and add it with an append fields at the end of each branch. Is there a better, easier way?

Something like a constant where I can refer to?

5 REPLIES 5
OTrieger
13 - Pulsar

@leonhekkert 

You can create it at the very beginning of the workflow and then with a Formula tool add it to the path name of each of the branches 

leonhekkert
8 - Asteroid

@OTrieger the different branches do not have the same starting point + its a very big flow with lots of summarizes etc. I'd rather not need to adjust the whole flow to get the time field downstream. 

PangHC
12 - Quasar

@leonhekkert you may utilize this datetime function?Screenshot 2025-03-27 172256.png

OTrieger
13 - Pulsar

@leonhekkert 

Then why you do not want to appended it to each of the branches?

leonhekkert
8 - Asteroid

Well, that would be my solution, but I was wondering if there was another easier way. DateTimeStart() seems to be just that! :)

Labels
Top Solution Authors