I'm writing to Oracle and using only In-DB tools. We are merging many fields from different tables together and throwing it on the Alteryx Server to be scheduled ran monthly.
My question is there a way to automatically include the month and year that the run is processed on at the end of the Table Name in the Write Data In-DB tool?
Solved! Go to Solution.
Hi @averyntxu ,
You can wrap the In-DB tools workflow into a macro and then have the date be the parameter getting updated with an Action tool.
Inside the Macro -
Workflow - the formula tool: DateTimeNow() -> DateTimeFormat([Date], "%Y-%m")
*I used DateTimeAdd to mimic different months that the workflow would be scheduled.
See attached packaged workflow.yxzp
Hope this helps!