SOLVED
Rename Oracle Table
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
dansnyder
5 - Atom
‎03-01-2021
10:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Database Connection
2 REPLIES 2
ImadZidan
12 - Quasar
‎03-01-2021
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
‎03-01-2021
10:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is what I was looking for, thank you!
