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.

Deleting records from an oracle table

NHagen1907
5 - Atom

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!

 

1 REPLY 1
BrandonB
Alteryx
Alteryx

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-...

 

Labels
Top Solution Authors