Nearest Warehouses (Lat, Lon)

This node can be used to calculate the n-nearest warehouses from a customer location.
For this node two input tables are needed. The first table should contain all warehouses addresses. The second table should contain all customer addresses. An address could be for example a customer, supplier, production plant or something else.
The warehouse assignment can be done based on parameter Street Level, if the parameter is 'on' he will assign warehouses based on the real road distance, if the parameter is 'off' he will assign warehouses based on the beeline distance.
Please specify the overall number of warehouses, distance unit, radius in which you want to find warehouse and street level option in the configuration dialogue.

In case input and output data need to be saved on the Log-hub Platform, please set save scenario flag to true, fill the workspace id for the workspace in which the scenario should be saved, and give name to the scenario. In case existing scenario should be overwritten, set the overwrite scenario flag also to true, otherwise leave to false.

To use this node you need an API Key from Log-hub Supply Chain Apps. This key you can generate with an Supply Chain Apps Pro Account. More information you can find on www.log-hub.com.

Log-hub video for API key generation:https://www.youtube.com/watch?v=FZgOn1IZ1Bk&t=255s

Options

Name* (Warehouses)
Please select the name column
Latitude* (Warehouses)
Please select the latitude column
Longitude* (Warehouses)
Please select the longitude column
Name* (Customers)
Please select the name column
Latitude* (Customers)
Please select the latitude column
Longitude* (Customers)
Please select the longitude column
Nearest Warehouses
Please specify the required number of nearest warehouses
Radius
Please specify the radius
Distance Unit
Please select the distance unit
Street Level (Parameters)
Please select the street level
Save Scenario (Save Scenario on Platform)
In order to save scenario on the Log-hub Platform, set the parameter to true
Overwrite Scenario (Save Scenario on Platform)
In order to overwrite existing scenario on Log-hub Platform, set the parameter to true
Workspace Id - workspace where Scenario should be saved (Save Scenario on Platform)
Please enter here the workspace id in which you want to save scenario
Scenario Name (Save Scenario on Platform)
Please enter scenario name
Log-hub API Key
Please enter here the API Key from Log-hub.

Input Ports

Icon
The warehouse input needs to contain name, country, state, zip, city and street. Mandatory fields are name and country. One of the columns zip or city should be filled. Please map the fields accordingly in the configuration.
Icon
The customers input needs to contain name, country, state, zip, city and street. Mandatory fields are name and country. One of the columns zip or city should be filled. Please map the fields accordingly in the configuration.

Output Ports

Icon
The nearest warehouse output contains all warehouse input data and their assigned customer input data and the distance between the warehouse and the customer.
Icon
The unassigned customer output contains all the customer that could not be assigned to warehouse.

Nodes

Extensions

Links