Icon

Adding missing values based on previous row value - with contiguous missing values

Adding missing values based on previous row value

using lag column to populate missing values from previous value and including calculation

This only works where there are NOT contiguous missing values These will additionally work for contiguousblocks of missing values Sample Datawith contigous blockof missing valuesand a missing valueon first rowbring down previous valuereplace missing valuesadd 1tidy uppopulate missing value with previous value + 1populate missing value with previous value + 1Use rowindex tomark "block starts" within order numberget ranking of rowwithin "block"add rank -1 to OrderPositionIDtidy upfill down missingvaluesfor block startand OrderPositionIDHandle missing valuethat could appear on first rowif it was originally missing(set it to zero)Extract Data Tablefrom Delimited Text Lag Column Rule Engine Math Formula Column Filter Java Snippet Column Expressions Rule Engine Rank Math Formula Column Filter Missing Value Missing Value This only works where there are NOT contiguous missing values These will additionally work for contiguousblocks of missing values Sample Datawith contigous blockof missing valuesand a missing valueon first rowbring down previous valuereplace missing valuesadd 1tidy uppopulate missing value with previous value + 1populate missing value with previous value + 1Use rowindex tomark "block starts" within order numberget ranking of rowwithin "block"add rank -1 to OrderPositionIDtidy upfill down missingvaluesfor block startand OrderPositionIDHandle missing valuethat could appear on first rowif it was originally missing(set it to zero)Extract Data Tablefrom Delimited Text Lag Column Rule Engine Math Formula Column Filter Java Snippet Column Expressions Rule Engine Rank Math Formula Column Filter Missing Value Missing Value

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: BATEB031
Created at: 2024-02-26
On NodePit since: 2024-02-26
Last update: 2024-11-21
Created with KNIME version: v4.7.8

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

Try NodePit Runner!