Data from KNIME to DB

KNIME Analytics Platform
1

Hi Team,

I want to write the data to DB before that delete the existing data in the DB and then write the Data into the same table.

Do we have any of such type nodes or any pattern of nodes.
Please suggest me.

Thanks,

2

Hello @Subramanyam ,
Yes, it is possible using the DB Writer Node

If you look at the configuration of the node, you will see an option Remove existing table.

image
image1219×867 89.9 KB

I hope this helps. Let me know if you have any questions.

Thanks,
Sanket

2 Likes