Deleting records from an 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
NHagen1907
5 - Atom
‎12-10-2020
11:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a workflow that appends records on a daily basis to an oracle table. For the current week I would like to keep all records, but for any prior week I would like to only keep those records that have an extract date of Friday. So when the year is done I should have one extract for each week, along with one extract for each day of the current week. Looking for some help.
Thanks!
Labels:
- Labels:
- Help
1 REPLY 1
Alteryx
‎12-10-2020
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Maybe you could use a PostSQL expression in your Output Data tool to perform this operation? Delete rows where the date is not Friday
