Delete records from db table

What is the easiest simpler way to run DELETE*FROM TEST1 query? Its quick to do odbc connection using input tool and put the SELECT*FROM TEST1 and get the result, however using same method when i write DELETE query, it errors out. I have both read and write access for the db table. I can use same DELETE query in the Sql server and b able to delete entire data table. Could someone provide suggestion?

Input

Accepted answers

ImadZidan

Hello @rajamahajan85 ,

Ok lets try this as a test for now. Run the attached flow and check if it creates a new table called

UU.auditf4tst. Also check if it has the 16 records

DeleteAppend.yxmd

All comments

vizAlter

@rajamahajan85 — Are you deleting everything from the Table while importing data through standard "Input" tool?

FYI, if you are using Input tool, the you can use standard "Filter" tool. You can put the condition in it for your "WHERE" clause (similar to SQL command).

If you are using "Data Stream In" tool, then there is a "Filter In-DB" tool.

(Hope, you are aware about both the tools, and did you try "Filter In-DB" tool?)

We use "Delete" to delete the records in SQL query, however, we use "Filter" to eliminate the records in Alteryx workflow.

rajamahajan85

Im not filtering data. I have a table in db which i need to first delete before i load data into it. My first step is to clean entire table and then append data to it.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335