Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Constant calculated by a formula

ScottShimer
7 - Meteor

I would like to base a workflow constant on the value of a calculation:

 

DateTimeAdd(DateTimeNow(), 1, "Months") = the next month based on when the workflow is executed.

 

I have a number of workflows that are based on the prior or next month and would like to set that as a constant so I don't have to add it to every record or keep calculating it with a formula.

 

Is there a way to assign a calculated value, like the one above, to a constant in the workflow?

 

Thanks,

Scott

2 REPLIES 2
paulfound
11 - Bolide

Hi @ScottShimer 

 

I haven't yet been able to find a way to dynamically edit a worksheets own constant. But you can update the XML of a workflow from one to another workflows,  so all you do is import the workflow in the input tool, formula tool with find and replace and output tool. This way when the next WF is opened it will have been updated with the new constant.

 

Hope this is of help, or at least food for thought. 

 

ScottShimer
7 - Meteor

Thanks, I will take a look at that approach.

Regards,
Scott

Labels