Icon

Examples

This directory contains 50 workflows.

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 - 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 […]

IconExcel - convert dataframe to mixed cells 

URL: Excel - write data with mixed types in one column - KNIME Forum (83801) […]

IconExcel - Convert to XML Spreadsheet 2003 

URL: Excel - Convert to XML Spreadsheet 2003 - KNIME Forum (83303) https://forum.knime.com/t/excel-to-xml-conversion/83303/5?u=mlauber71 URL: Medium Blog: […]

IconExcel - Formula Evaluation in KNIME 

URL: AF Utility Nodes - Excel https://hub.knime.com/search?tag=ExcelUtil URL: AP-17559 - Problems with evaluation formulas in Excel Writer […]

IconExcel - Import very large File with Python and Apache Arrow 

URL: HUB: import a large Excel file with 2,000 columns and 25,000 lines - 300 MB size https://hub.knime.com/-/spaces/-/latest/~JMizGmYie07na416/ URL: KNIME […]