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