HOW TO MOVE EXCEL FILE AFTER LOADING TO DB

Can someone give me some pointers I’m pretty new to Knime. I have Excel Files that are being read from a directory in the server and getting read and loaded into a sql server db using db writer. How do I move the files after being inserted into the sql server database into another location.
for example:
Source: …\incoming
Processed directory: …\Processed

Appreciate help on this topic.

I’m on version KNIME 4.7.1

You can try to use the Delete Files/Folders node after insert into DB.

Thanks for your response but I want to move the files to another directory after writing to database.

Use the Transfer Files node instead. It’s a pretty straightforward node where it asks you to provide a source and destination.

If the file always has the same name then use the browse option. Otherwise you need to make this flow variable controlled and dynamically pass the path of the Excel file from the Excel Writer node.

3 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.