Icon

Find first non missing and filter rows

Sample Dataget row index for each id thatis presentFind first rowindexcontaining a valueas variableFilter all earlierrowsConvert to IntegerFind first rowindexcontaining a valueApply "min" value-not-missingto all columnsFilter thosewith earlier row indexget row index for each id thatis presentFilter thosewith earlier row indexTidy upTidy upTidy upMark rows to keepFilter off rows marked "RowFilter=true"Tidy upTable Creator Rule Engine GroupBy Table Rowto Variable Row Filter Math Formula GroupBy Cross Joiner Rule-basedRow Filter Rule Engine Rule-basedRow Filter Column Filter Column Filter Column Filter Java Snippet Row Filter Column Filter Sample Dataget row index for each id thatis presentFind first rowindexcontaining a valueas variableFilter all earlierrowsConvert to IntegerFind first rowindexcontaining a valueApply "min" value-not-missingto all columnsFilter thosewith earlier row indexget row index for each id thatis presentFilter thosewith earlier row indexTidy upTidy upTidy upMark rows to keepFilter off rows marked "RowFilter=true"Tidy upTable Creator Rule Engine GroupBy Table Rowto Variable Row Filter Math Formula GroupBy Cross Joiner Rule-basedRow Filter Rule Engine Rule-basedRow Filter Column Filter Column Filter Column Filter Java Snippet Row Filter Column 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: @takbb Brian Bates
Created at: 2021-07-06
On NodePit since: 2022-02-06
Last update: 2024-04-30
Created with KNIME version: v4.3.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!