Icon

kn_​forum_​calculate_​distances

Calculate Distance Based on Set Up Point

Calculate Distance Based on Set Up Point

Calculate Distance Based on Set Up Point https://forum.knime.com/t/calculate-distance-based-on-set-up-point/20141/9?u=mlauber71 Node 31Raw PointRaw CenterA, B, CNode 35join Point ANode 37Node 38Calculate Point Asave RowIDin new IDCoordinate_A$Point$ = "A" => TRUEdistance_A$Point$ = "B" => TRUECoordinate_Bdistance_BNode 63Calculate Point BNode 65join Point BCalculate Point Cdistance_Cjoin Point CNode 70Node 71$Point$ = "C" => TRUECoordinate_CNode 74Node 75transpose thevaluesalternative:write a Rulefind minimum distancejoinby ID andminimum distancesee resultNode 83remove "distance_"partRaw_Point_Result.xlsx Latitude/Longitudeto Coordinate Excel Reader (XLS) Excel Reader (XLS) Latitude/Longitudeto Coordinate Joiner Geo Distances Geo Distances Column Distance Java Snippet(simple) Column Rename Rule-basedRow Filter Column Rename Rule-basedRow Filter Column Rename Column Rename Geo Distances Column Distance Geo Distances Joiner Column Distance Column Rename Joiner Geo Distances Geo Distances Rule-basedRow Filter Column Rename Joiner Joiner Unpivoting GroupBy Joiner Joiner Column Rename String Manipulation Excel SheetAppender (XLS) Calculate Distance Based on Set Up Point https://forum.knime.com/t/calculate-distance-based-on-set-up-point/20141/9?u=mlauber71 Node 31Raw PointRaw CenterA, B, CNode 35join Point ANode 37Node 38Calculate Point Asave RowIDin new IDCoordinate_A$Point$ = "A" => TRUEdistance_A$Point$ = "B" => TRUECoordinate_Bdistance_BNode 63Calculate Point BNode 65join Point BCalculate Point Cdistance_Cjoin Point CNode 70Node 71$Point$ = "C" => TRUECoordinate_CNode 74Node 75transpose thevaluesalternative:write a Rulefind minimum distancejoinby ID andminimum distancesee resultNode 83remove "distance_"partRaw_Point_Result.xlsxLatitude/Longitudeto Coordinate Excel Reader (XLS) Excel Reader (XLS) Latitude/Longitudeto Coordinate Joiner Geo Distances Geo Distances Column Distance Java Snippet(simple) Column Rename Rule-basedRow Filter Column Rename Rule-basedRow Filter Column Rename Column Rename Geo Distances Column Distance Geo Distances Joiner Column Distance Column Rename Joiner Geo Distances Geo Distances Rule-basedRow Filter Column Rename Joiner Joiner Unpivoting GroupBy Joiner Joiner Column Rename String Manipulation Excel SheetAppender (XLS)

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: yunan.ay
Created at: 2019-12-23
On NodePit since: 2019-12-23
Last update: 2024-11-18
Created with KNIME version: v4.1.0
Tags: calculatedistancepalladium

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

Try NodePit Runner!