I have created a workflow that runs weekly to overwrite data in an Oracle database table. Before writing the output to Oracle each week, I would like to rename the current version of the table with today's date appended, so we can look back at the output through time. I believe this is possible in SQL with a RENAME TABLE query, but I cannot figure out how to do this in an Alteryx workflow.
Solved! Go to Solution.
Hello @dansnyder ,
Have you tried to explored the below option in the outputData tool.
Look at the Pre Create SQL statement. It is possible to have you RENAME command there.
Have a look.
This is what I was looking for, thank you!