Icon

Find_​Closest_​Date_​tuned

Sample dataTranslate toactual datesJoin all rows within a countryto all other rowsfor that countryGet difference in days betweendatesDates matched withImportant DatesOnlyAbsolute difference(ignore sign)DiscardImportant DatesFind Min DifferenceBy Country and Row CounterUse joiner to filteronly those originalrows matchinga minimum dateTidy upApply resultsback to originaldata setusing LeftOuter Joinon counter(and remove counter columns as a tidy-up)Rename to "Important Date"and"Closest Important Day"Node 16top: regularbottom: importantmerge join columns enabledfewer output columnsunchangedunchangedunchangedcondition: country removedfewer output columnsusing "Merge join columns"gives wrong output columns?!unchangedunchangedTable Creator String to Date&Time Joiner Date&TimeDifference Row Filter Math Formula Row Filter GroupBy Joiner Column Filter Joiner Column Rename Math Formula Row Splitter Joiner Date&TimeDifference Math Formula GroupBy Joiner Column Rename Joiner Sample dataTranslate toactual datesJoin all rows within a countryto all other rowsfor that countryGet difference in days betweendatesDates matched withImportant DatesOnlyAbsolute difference(ignore sign)DiscardImportant DatesFind Min DifferenceBy Country and Row CounterUse joiner to filteronly those originalrows matchinga minimum dateTidy upApply resultsback to originaldata setusing LeftOuter Joinon counter(and remove counter columns as a tidy-up)Rename to "Important Date"and"Closest Important Day"Node 16top: regularbottom: importantmerge join columns enabledfewer output columnsunchangedunchangedunchangedcondition: country removedfewer output columnsusing "Merge join columns"gives wrong output columns?!unchangedunchangedTable Creator String to Date&Time Joiner Date&TimeDifference Row Filter Math Formula Row Filter GroupBy Joiner Column Filter Joiner Column Rename Math Formula Row Splitter Joiner Date&TimeDifference Math Formula GroupBy Joiner Column Rename 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: brian
Created at: 2022-01-05
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.5.0

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

Try NodePit Runner!