Public
This directory contains 394 workflows.
kn_example_db_h2_primary_key
Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
kn_example_db_h2_update_in_databse
H2 do an UPDATE on the server using a VIEW of the existing and the new data
kn_example_db_loop_multiple_tables
Identify tables in you database(s) and loop over them and store the data in a CSV file
kn_example_db_mysql
create table in MySQL
kn_example_db_mysql_where_clause
create table in MySQL and create a dynamic WHERE clause with integers and strings
kn_example_db_paradox_corel
Load a Borland/Corel Paradox SQL database into KNIME with a JDBC driver
kn_example_db_sqlite_python_sql
KNIME, Python and SQL with local SQLite database Some examples how to interact with a (local) SQLite database with SQL commands via Python (Jupyter […]
kn_example_db_sqlite_right_joiner_loop
I built a workflow that does that also to play around with SQLite and to see what it could do. I have two databases that both have two tables named […]
kn_example_db_sqlite_switch_query
DB SQLite - switch datase source based on a case when selection
kn_example_db_sqlite_timestamp
Play around with SQLite and Date and Time functions