Icon

Find Closest Date

Sample dataTranslate toactual datesApply a sequentialrow counterto be used forjoining back againlaterJoin 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"Table Creator String to Date&Time Counter Generation Joiner Date&TimeDifference Row Filter Math Formula Row Filter GroupBy Joiner Column Filter Joiner Column Rename Sample dataTranslate toactual datesApply a sequentialrow counterto be used forjoining back againlaterJoin 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"Table Creator String to Date&Time Counter Generation Joiner Date&TimeDifference Row Filter Math Formula Row Filter GroupBy Joiner Column Filter Joiner Column Rename

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!