Icon

Compare with previous event-python-pandasql alternative

Alternative solution for those who knowSQL using a python-based component Range join using pandasql(SQLite syntax)Sample DataConvert to DateTimeFind 45 mins after each eventas "Event end time"Keep only the Event End timewhere "Important=Yes"Fill down Import event"end times" from aboveMark those events that are prior to important event end timeGet Important Events PandaSQL Join Table Creator String to Date&Time Date&Time Shift Rule Engine Missing Value Rule Engine Row Filter Alternative solution for those who knowSQL using a python-based component Range join using pandasql(SQLite syntax)Sample DataConvert to DateTimeFind 45 mins after each eventas "Event end time"Keep only the Event End timewhere "Important=Yes"Fill down Import event"end times" from aboveMark those events that are prior to important event end timeGet Important EventsPandaSQL Join Table Creator String to Date&Time Date&Time Shift Rule Engine Missing Value Rule Engine Row Filter

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: brian
Created at: 2021-11-15
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.4.1

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

Try NodePit Runner!