How do I use records from CSV file and update DB

KNIME Analytics Platform
1

How can I import the data from a csv file and update a data base connected to KNIME

I need update a database connected to KNIME, using data from a CSV file containing 8k records, with 3 columns and update each row one by one after a .bat file is triggered to a table in SQL Server.

Also Can I pass the values (row values) in a loop, like an iteration after a .bat file is triggered

2

Have a look at the DB Nodes, e.g DB Excecuter node
br

3

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