Icon

m_​000_​db_​h2_​prepare_​time_​data

Prepare data to demonstrate a BETWEEN Join with KNIME and H2 database

Prepare data to demonstrate a BETWEEN Join with KNIME and H2 database
this is not a particulary sophisticated data set - just to get two table with timestamps to match

Prepare data to demonstrate a BETWEEN Join with KNIME and H2 databasethis is not a particulary sophisticated data set - just to get two table with timestamps to match Load data:https://www.kaggle.com/competitions/ashrae-energy-prediction/data train.csvweather_train.csvNode 4randomNode 7Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16random1-100Node 20v_random_id$v_random_id$ <= 5000 => TRUETRUE => FALSEkeep only 5.000 linesNode 23../data/measures.table../data/intervals.table CSV Reader CSV Reader Column Filter String to Date&Time Random NumberAssigner (Apache) Double To Int Rule-basedRow Filter Date&Time Shift Column Rename GroupBy Column Filter Column Rename String to Date&Time GroupBy Random NumberAssigner (Apache) Sorter Java Snippet(simple) Rule-basedRow Filter Column Filter Table Writer Table Writer Prepare data to demonstrate a BETWEEN Join with KNIME and H2 databasethis is not a particulary sophisticated data set - just to get two table with timestamps to match Load data:https://www.kaggle.com/competitions/ashrae-energy-prediction/data train.csvweather_train.csvNode 4randomNode 7Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16random1-100Node 20v_random_id$v_random_id$ <= 5000 => TRUETRUE => FALSEkeep only 5.000 linesNode 23../data/measures.table../data/intervals.table CSV Reader CSV Reader Column Filter String to Date&Time Random NumberAssigner (Apache) Double To Int Rule-basedRow Filter Date&Time Shift Column Rename GroupBy Column Filter Column Rename String to Date&Time GroupBy Random NumberAssigner (Apache) Sorter Java Snippet(simple) Rule-basedRow Filter Column Filter Table Writer Table Writer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2020-09-18
On NodePit since: 2020-09-19
Last update: 2024-04-27
Created with KNIME version: v4.7.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!