Icon

GroupByDistance3

sampla data format1 attempt 1, sort by latitude attempt 3, cross-join attempt 2: sort by timestamp; use geographical and time distance cooperativesampledistanceNode 37Node 38Node 39Node 40Node 41Node 42Node 43Node 50Node 51Node 52malicioussamplecooperativesamplemalicioussamplesort byuser ASCtimestamp ASCdistanceNode 58Node 61Node 65Node 66Node 67Node 68Node 69Node 70Node 71Node 72lag Latlag Longfill missingclustersassign clustersvia distancethresholdtestresultcalcdistancefill missingcoordsdate&timedifferenceappendclusteraggregatefinal result Table Creator Column Expressions Sorter String To Number Lag Column Lag Column Rule Engine Rule Engine Column Rename Rule Engine Missing Value GroupBy Table Creator Table Creator Table Creator Sorter Column Expressions Column Rename GroupBy Sorter Column Resorter Row Splitter DuplicateRow Filter Column Filter Cross Joiner String To Number Column Rename Lag Column Lag Column Missing Value Rule Engine GroupBy Column Expressions Missing Value Date&TimeDifference Joiner GroupBy sampla data format1 attempt 1, sort by latitude attempt 3, cross-join attempt 2: sort by timestamp; use geographical and time distance cooperativesampledistanceNode 37Node 38Node 39Node 40Node 41Node 42Node 43Node 50Node 51Node 52malicioussamplecooperativesamplemalicioussamplesort byuser ASCtimestamp ASCdistanceNode 58Node 61Node 65Node 66Node 67Node 68Node 69Node 70Node 71Node 72lag Latlag Longfill missingclustersassign clustersvia distancethresholdtestresultcalcdistancefill missingcoordsdate&timedifferenceappendclusteraggregatefinal resultTable Creator Column Expressions Sorter String To Number Lag Column Lag Column Rule Engine Rule Engine Column Rename Rule Engine Missing Value GroupBy Table Creator Table Creator Table Creator Sorter Column Expressions Column Rename GroupBy Sorter Column Resorter Row Splitter DuplicateRow Filter Column Filter Cross Joiner String To Number Column Rename Lag Column Lag Column Missing Value Rule Engine GroupBy Column Expressions Missing Value Date&TimeDifference Joiner 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: azivec
Created at: 2022-01-13
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!