Icon

Challenge_​20_​Patient_​Network_​Days

Challenge_20_Patient_Network_Days
Create input dataLoop by UniquePatientSort dates ascendingExtract previousdateCreate date rangebased on end and start dateEnd and Start dateto VariableFilter out missingdateLoop each rowExtract day of weeknameExclude Weekend daysCount network daysInner loop endOuter loop endCalculate mean daysAdd mean days to each rowRenameNode 21Filter out missingdateFilter helpersSort to match outputTable Creator Group Loop Start Sorter Lag Column Create Date&TimeRange Table Rowto Variable Row Filter Window Loop Start Extract Date&TimeFields Rule-basedRow Filter GroupBy Column Appender Loop End Loop End GroupBy Column Appender Missing Value Column Rename Concatenate Row Filter Column Filter Column Resorter Create input dataLoop by UniquePatientSort dates ascendingExtract previousdateCreate date rangebased on end and start dateEnd and Start dateto VariableFilter out missingdateLoop each rowExtract day of weeknameExclude Weekend daysCount network daysInner loop endOuter loop endCalculate mean daysAdd mean days to each rowRenameNode 21Filter out missingdateFilter helpersSort to match outputTable Creator Group Loop Start Sorter Lag Column Create Date&TimeRange Table Rowto Variable Row Filter Window Loop Start Extract Date&TimeFields Rule-basedRow Filter GroupBy Column Appender Loop End Loop End GroupBy Column Appender Missing Value Column Rename Concatenate Row Filter Column Filter Column Resorter

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: siito
Created at: 2022-06-08
On NodePit since: 2022-06-09
Last update: 2024-11-21
Created with KNIME version: v4.5.2
Tags: justknimeit-20Network days

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

Try NodePit Runner!