The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Adding a time constant to several branches in a workflow

leonhekkert
Asteroide

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 RESPOSTAS 5
OTrieger
Magnetar

@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
Asteroide

@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. 

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

OTrieger
Magnetar

@leonhekkert 

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

leonhekkert
Asteroide

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

Rótulos
Autores com maior número de soluções