Alteryx Designer Desktop Discussions

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

Rename Oracle Table

dansnyder
5 - Atom

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.

2 REPLIES 2
ImadZidan
12 - Quasar

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.

 

PreCreate.PNG

dansnyder
5 - Atom

This is what I was looking for, thank you!

Labels
Top Solution Authors