Auto Writing Monthly Cuts Date in Table Name

Question

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 Answer

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!