Icon

Counting the max of consecutive days in error - with or without component

Identify Groups Identify groups and determine count Determine count Find maximum, and return "error" value dataPlace a value tobe cumulativelysummed by groupGrouping on change of valueof Results ColumnResultfor maximumget "result" fromprevious rowidentify switch pointcreate groupsget countfor each groupResultfor maximumJust errorJust error Table Creator Math Formula Cumulative Sumfor Grouping GroupBy Lag Column Rule Engine Missing Value GroupBy GroupBy Row Filter Row Filter Identify Groups Identify groups and determine count Determine count Find maximum, and return "error" value dataPlace a value tobe cumulativelysummed by groupGrouping on change of valueof Results ColumnResultfor maximumget "result" fromprevious rowidentify switch pointcreate groupsget countfor each groupResultfor maximumJust errorJust errorTable Creator Math Formula Cumulative Sumfor Grouping GroupBy Lag Column Rule Engine Missing Value GroupBy GroupBy Row Filter 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: adrferreira
Created at: 2023-06-19
On NodePit since: 2023-06-19
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!