Icon

DateClustering 2023-01-10

Generate sample data Create OneYear of ValuesSelectDates toInclude(random< x)Filter outexcluded (0)Calculate daysdifferencefrom reference timeManhattanDistance on one variable isdays between anytwo rowsGet last dateAs referencetimeCalculateClustersViewClustersAssign DataTo ClustersMaxDistanceIn Date(Days)Calculate 7days as normaliseddistanceAs a target thresholdClusters anddates in cluster Create Date&TimeRange Math Formula Row Filter Date&TimeDifference Numeric Distances GroupBy Table Rowto Variable Hierarchical Clustering(DistMatrix) HierarchicalCluster View Hierarchical ClusterAssigner (local) GroupBy Math Formula Table Rowto Variable GroupBy Generate sample data Create OneYear of ValuesSelectDates toInclude(random< x)Filter outexcluded (0)Calculate daysdifferencefrom reference timeManhattanDistance on one variable isdays between anytwo rowsGet last dateAs referencetimeCalculateClustersViewClustersAssign DataTo ClustersMaxDistanceIn Date(Days)Calculate 7days as normaliseddistanceAs a target thresholdClusters anddates in cluster Create Date&TimeRange Math Formula Row Filter Date&TimeDifference Numeric Distances GroupBy Table Rowto Variable Hierarchical Clustering(DistMatrix) HierarchicalCluster View Hierarchical ClusterAssigner (local) GroupBy Math Formula Table Rowto Variable GroupBy

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: DavidPlummer
Created at: 2023-01-10
On NodePit since: 2023-01-11
Last update: 2024-04-27
Created with KNIME version: v4.7.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!