how to delete specific record using where option from SQL table?

Question

I have a table in SQL with column name "source" and has values A, B, C. I want to delete records with source C every time I run Alteryx flow. Once deleted, Again I have to append fresh excel file into SQL table for source C every time I run. Total number of records are 500,000.

I connected excel using  "Input tool" and  sql table using "output tool" . Then used  Pre SQL query on output tool "delete from [tablename] where source = 'C' " and selected "Append Existing" in output option. But it is taking  more than 7 hours to run and not deleting the records. Also it is not appending fresh records.

Can someone please help?

imranmunshi · Answer

Hello TreVorS,

thank you for the reply.

Here attached the snapshot of my workflow and queries which I have written.

regards,

Imran

Alteryx-Delete Query-1.png

Alteryx-Delete Query-2.png

TrevorS · Answer

Hello @imranmunshi

Are you able to upload a copy of your workflow and some sample data?

This will help the community to troubleshoot if the issue is within the workflow.

Additionally, some issues which can lead to slow workflow times can possibly be handled with some optimization.

Please check out the article Tips & Tricks 2016: Workflow Optimization for some options which may help to speed up your processes.

Thanks!

TrevorS