Icon

extract missing numbers from column

input dataidentify minmax valuein input datacreate columnwith data rangebased on mix max valueiteration column +1collect resultsmissing_numbersmissing_numberscreate group_idcreate group_idgroup_idExcel Reader GroupBy Table Rowto Variable Counting Loop Start Math Formula Loop End Column Filter Joiner Rule Engine Lag Column Rule Engine Missing Value GroupBy input dataidentify minmax valuein input datacreate columnwith data rangebased on mix max valueiteration column +1collect resultsmissing_numbersmissing_numberscreate group_idcreate group_idgroup_idExcel Reader GroupBy Table Rowto Variable Counting Loop Start Math Formula Loop End Column Filter Joiner Rule Engine Lag Column Rule Engine Missing Value GroupBy

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: hans
Created at: 2023-09-27
On NodePit since: 2023-11-01
Last update: 2024-05-01
Created with KNIME version: v4.7.3

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

Try NodePit Runner!