Prepare the Northwind Database

0 ×

These tables are included in the local database
knime://knime.workflow/../data/Northwind_small.h2

(they all have a unique ID "id")

shipper
product
customerdemographic
employee
customercustomerdemo
supplier
orders
category
region
employeeterritory
customer
orderdetail
territory

one VIEW with a combination of informations
productdetails_v

URL: northwind-SQLite3/Northwind_small.sqlite https://github.com/jpwhite3/northwind-SQLite3/blob/master/Northwind_small.sqlite
URL: SQL H2 - more examples https://hub.knime.com/search?tag=H2&type=Workflow

Nodes

• DB Query Reader (Labs)5 ×
• DB SQL Executor (Labs)5 ×
• Java Edit Variable (simple)3 ×
• Column Expressions2 ×
• Rule Engine2 ×
• Show all 28 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Column Expressions (Labs)
• FeatureKNIME Database
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available