Icon

KNIME_​PSA_​Closest_​Not_​Later_​Than

Patient Diagnosis DatePatient Test DatesPatients with Diag Date andTest Date.Done it as an outer join in case there are patients forwhom there is noTest Date showingGet Difference in daysbetween test date anddiagnosis dateBase column: test dateCompare diff to: diag dateI've done the test this way round soPOSITIVE difference means test was BEFORE diagnosisFilter out any negativeday differencesFor each patient,get row with MAXIMUMtest datePatients with ID,Diagnosis DateLast Test ON OR BEFOREDiagnosis DateOuter join to ensure allpatients appear even ifno test date is shownTable Creator Table Creator Joiner Date&TimeDifference Row Filter GroupBy Joiner Patient Diagnosis DatePatient Test DatesPatients with Diag Date andTest Date.Done it as an outer join in case there are patients forwhom there is noTest Date showingGet Difference in daysbetween test date anddiagnosis dateBase column: test dateCompare diff to: diag dateI've done the test this way round soPOSITIVE difference means test was BEFORE diagnosisFilter out any negativeday differencesFor each patient,get row with MAXIMUMtest datePatients with ID,Diagnosis DateLast Test ON OR BEFOREDiagnosis DateOuter join to ensure allpatients appear even ifno test date is shownTable Creator Table Creator Joiner Date&TimeDifference Row Filter GroupBy Joiner

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-05-11
On NodePit since: 2022-02-06
Last update: 2024-05-01
Created with KNIME version: v4.3.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!