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!
Maybe you could use a PostSQL expression in your Output Data tool to perform this operation? Delete rows where the date is not Friday