Icon

Exclude_​Only_​Last_​NA_​values2

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 edgekeepsingle columnand new_idreverse sort columnnew_idcheck if invers LAG ismissingNode 11rowwhere the edgeissplit intorows to be processedand the ones left outapply missing valueslist columnsto be processedv_regex_patternx_process_colcollect ressultsSTART Table Creator Rule Engine Column Filter Sorter Java Snippet(simple) Lag Column GroupBy Rule-basedRow Filter Table Rowto Variable Rule-basedRow Splitter Missing Value Concatenate ExtractColumn Header Transpose Java EditVariable (simple) Column Rename Column Filter Loop End (ColumnAppend) Table Row ToVariable Loop Start 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 edgekeepsingle columnand new_idreverse sort columnnew_idcheck if invers LAG ismissingNode 11rowwhere the edgeissplit intorows to be processedand the ones left outapply missing valueslist columnsto be processedv_regex_patternx_process_colcollect ressultsSTARTTable Creator Rule Engine Column Filter Sorter Java Snippet(simple) Lag Column GroupBy Rule-basedRow Filter Table Rowto Variable Rule-basedRow Splitter Missing Value Concatenate ExtractColumn Header Transpose Java EditVariable (simple) Column Rename Column Filter Loop End (ColumnAppend) Table Row ToVariable Loop Start

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!