Icon

Exclude_​Only_​Last_​NA_​values3

https://forum.knime.com/t/exclude-missing-values-from-the-end-of-a-dataset/21656/3?u=mlauber71 Please keep missing values at the end of each variablebut replace any missing valuein between.find the edgereverse sort columnnew_idcheck if invers LAG ismissingNode 11rowwhere the edgeissplit intorows to be processedand the ones left outx_process_colcollect ressults^(?!new_id$).*Previous valuekeep 10rowsApply previous valueNext valueApply next value Table Creator Rule Engine Sorter Java Snippet(simple) Lag Column GroupBy Rule-basedRow Filter Table Rowto Variable Rule-basedRow Splitter Concatenate Column Rename Loop End (ColumnAppend) Column ListLoop Start Missing Value Row Filter Missing Value(Apply) Missing Value Missing Value(Apply) https://forum.knime.com/t/exclude-missing-values-from-the-end-of-a-dataset/21656/3?u=mlauber71 Please keep missing values at the end of each variablebut replace any missing valuein between.find the edgereverse sort columnnew_idcheck if invers LAG ismissingNode 11rowwhere the edgeissplit intorows to be processedand the ones left outx_process_colcollect ressults^(?!new_id$).*Previous valuekeep 10rowsApply previous valueNext valueApply next valueTable Creator Rule Engine Sorter Java Snippet(simple) Lag Column GroupBy Rule-basedRow Filter Table Rowto Variable Rule-basedRow Splitter Concatenate Column Rename Loop End (ColumnAppend) Column ListLoop Start Missing Value Row Filter Missing Value(Apply) Missing Value Missing Value(Apply)

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: Dr.Marsellos
Created at: 2020-03-10
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.1.2

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

Try NodePit Runner!