Auto Writing Monthly Cuts Date in Table Name

[averyntxu]

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?

[JessieC · Accepted 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!