In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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