Hi, I’d like to put some data from an Excel file into a Database in KNIME so that I can use SQL query nodes on it. I’m struggling with it, because all of the database nodes seem to require a database as an input. This seems like it should be really simple, but I can’t seem to figure it out. Can someone help me figure this out?
You could start with the upper part of this workflow. Loading a KNIME table into a data base
In the link section there is a link to the database guide and there are more examples on the hub
1 Like
Hello @stevelp,
you can not create a database from table. You can write table to already existing database. And to do that you need to obtain a database connection…
Br,
Ivan
1 Like
This is exactly what I needed. Thanks!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.