Icon

Route Optimization

<p><strong>Route Optimization</strong></p><p>This workflow integrates warehouse and production facility locations to determine the optimal route from a selected production site to all warehouses. Its objective is to solve the Travelling Salesman Problem (TSP), which seeks the shortest possible route that visits each warehouse at least once and returns to the starting point.</p><p>The workflow computes distances and travel times for all origin–destination pairs and converts these into user-friendly units such as kilometers and hours. It then allows to choose between two optimization strategies—Nearest Neighbor or Mixed-Integer Linear Programming—to identify the best routes. The resulting optimal routs and locations are visualized in an interactive dashboard featuring geomaps and network graphs.</p>

Route Optimization

This workflow integrates warehouse and production facility locations to determine the optimal route from a selected production site to all warehouses. Its objective is to solve the Travelling Salesman Problem (TSP), which seeks the shortest possible route that visits each warehouse at least once and returns to the starting point.

The workflow computes distances and travel times for all origin–destination pairs and converts these into user-friendly units such as kilometers and hours. It then allows to choose between two optimization strategies—Nearest Neighbor or Mixed-Integer Linear Programming—to identify the best routes. The resulting optimal routs and locations are visualized in an interactive dashboard featuring geomaps and network graphs.

Data Reading
Compute location geometry and distance/route matrix
View Optimal Route
Get locationgeometries
OSM Boundary Map Table
Column Renamer
Open view to interactand compute optimal route
View Optimal Route
Concatenate
Warehouse locations
Excel Reader
Origin toDestinationpath
Expression
Duration -> hourDistance -> km
Data conversion
Get route,distanceand duration
OSRM Distance Matrix
Remove locationswhere distance = 0same city
Row Filter
Column Renamer
Production facilities
Excel Reader

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: Roberto.Cadili
Created at: 2026-03-10
On NodePit since: 2026-03-28
Last update: 2026-03-28
Created with KNIME version: v5.11.0
Tags: Supply chainManufacturingTravelling Salesman ProblemShortest routeSalesGeospatial analyticsNetwork graphs

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

Try NodePit Runner!