this demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform database operations on.
Workflow 
KNIME and SQLite - simple example (3.7 Legacy DB nodes)
Used extensions & nodes
Created with KNIME Analytics Platform version 4.0.2
Note: Not all extensions may be displayed.
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.0.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.0.2
Loading deployments
Loading ad hoc executions
Legal
By using or downloading the workflow, you agree to our terms and conditions.