Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎12-10-2020 11:07 AM

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:
Reply
0 Likes
1 REPLY 1
BrandonB
Alteryx
Alteryx
‎12-10-2020 11:33 AM

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

 

Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All