Example how to use H2 database to create table with upload and from scratch
H2 is an SQL database that 'lives' in a single file on your disk or in memory so you have a fully functional databse at your fingertips.
An alternative (maybe mor robust) would be SQLite
External resources
- If you want to use WINDOW functions like RANK with H2 you can easily update the H2 driver
- use H2 to produce a Position / Rank number within a group variable (window functions)
- more H2 database examples from the KNIME hub
- Example of H2 database - handling of database structure and use of Primary Keys - insert only new lines by ID
- H2 Database cheatsheet
- use H2 and KNIME to realize a BETWEEN match of timestamps
- KNIME Database Extension Guide
- forum entry
- H2 supported datatypes
- H2 Database Engine
- H2 java based database example
Used extensions & nodes
Created with KNIME Analytics Platform version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.5.0
Legal
By using or downloading the workflow, you agree to our terms and conditions.