Public

This directory contains 400 workflows.

kn_example_db_sqlite_right_joiner_loop

I built a workflow that does that also to play around with SQLite and to see what it could do. I have two databases that both have two tables named […]

kn_example_db_sqlite_switch_query

DB SQLite - switch datase source based on a case when selection

kn_example_db_sqlite_timestamp

Play around with SQLite and Date and Time functions

kn_example_db_sqlite_window_rank_timestamp

SQLite - Window function and Rank to detect duplicates - also using automatic ID and […]

kn_example_db_update_merge

demonstrates the use of DB Update and DB Merge

kn_example_db_update_merge_ms_access

demonstrates the use of DB Update and DB Merge with MS Access DB alse: extract some mea information from information_schema

kn_example_db_wait_execute

use the Wait node to execute a database query at fixed times Please note: If the time of day has passed when the workflow reaches the Wait node it will […]

kn_example_decision_tree

A simple decision tree with all the possibilities to store the results (as PMML or Ruleset or SQL Code) and evaluation (ROC curve)

kn_example_duplicates

I set up a workflow to demonstrate how this could be done - use group by to calculate how many duplicates there are (note: KNIME should introduce a generic […]

kn_example_duplicates_school_of

Dealing with duplicates is a constant theme with data scientist. And a lot of things can go wrong. The easienst ways to deal with them is GROUP BY or […]