Icon

Examples

This directory contains 58 workflows.

IconCSV - Automatically Detect Separators 

URL: How to set up Python extensions in KNIME https://www.knime.com/blog/how-to-setup-the-python-extension URL: Automatically detect the separator in a CSV […]

IconData App - Iterate Over List with manual Click 

URL: Iterate over List with manual clicks - or try to automate it - KNIME Forum (84541) […]

IconDB SQL - DuckDB in Memory and as local File 

URL: Maven - DuckDB Driver .jar https://mvnrepository.com/artifact/org.duckdb/duckdb_jdbc URL: DuckDB - toy around with KNIME and SQL […]

IconDB SQL - H2 Database dynamic Query with datetime 

URL: Create a DB Query in KNIME to only give back the latest values after a certain date - KNIME Forum (83720) […]

IconDB SQL - H2 Database, create database and additional tables 

URL: KNIME, Databases and SQL https://medium.com/p/273e27c9702a URL: Practicing with Traditional Databases […]

IconDB SQL - H2 Database, Insert Data - Bulk, Load and SQL Executor 

URL: DB SQL - H2 Database, Insert Data - Bulk, Load and SQL Executor - KNIME Forum (77635) […]

IconDB SQL - H2 School of duplicates - and how to deal with them 

URL: long forum debate about duplicates https://forum.knime.com/t/remove-rows-with-duplicate-values/11105/15?u=mlauber71 URL: School of duplicates - and how […]

IconDB SQL - MS Access - Multi-Value Fields 

URL: UCanAccess - A pure Java JDBC driver for Microsoft Access database files https://sourceforge.net/projects/ucanaccess/ URL: KNIME and MS Access […]

IconDB SQL - PostgreSQL - Upload binary files to database 

URL: Related forum topic https://forum.knime.com/t/inserting-binary-data-into-sql-database-using-knime/77927/5?u=takbb URL: KNIME Forum (88079) - Images to […]

IconDB SQL - SQLite - store and read JPEG Files in databases - also using Python 

In KNIME there does not seem to be a direct way to store JPG/JPEG files in SQLite. But you can use the bundled Python to load files into a SQLite […]