SQLite - Delete all rows from a table

KNIME Analytics Platform
1

Hi,

I have a workflow that writes data to SQLite database. What I need to do is add a module(s) to delete all the rows before new data is written to the table.

I tried to use the Database delete node but no joy... 

tC/.

2

Hi,

you can use the Database SQL Executor node to execute a "delete from tableName" statement. If you do not add a where clause SQLite is optimizing the execution. See Truncate in the documentation.

Bye

Tobias