Deleting records from an oracle table

NHagen1907

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!

BrandonB

Maybe you could use a PostSQL expression in your Output Data tool to perform this operation? Delete rows where the date is not Friday

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Pre-Post-SQL-Statements/ta-p/151965