I just started to use Knime. I have one question, please who knows help me.
I have a excel file (File1) in sharepoint and my task is to put this File1 to SQL database by using Knime.
Data in File1 is changed daily.
So, I need to do a flow in knime where I take Excel file from Sharepoint and via Knime put it into SQL DB. But excel file is changed daily, that’s why data from yesterday should be deleted before putting a new one.
You can configure the DB Writer node to delete and recreate the table in the SQL database corresponding to the data structure. There should be a checkbox in the configuration window to delete the table.
Hopefully this helps somewhat, but if not or if you have more questions please reach out again!