Hub
Pricing About
WorkflowWorkflow

Bulk Distance Calculation with Caching and Exception Handling

Distance CalculationSupply Chain OptimizationRoad-level RoutesCache Management
loghub profile image
Draft Latest edits on 
Oct 17, 2024 7:46 AM
Drag & drop
Like
Download workflow
Workflow preview
This KNIME workflow is designed for Supply Chain Analytics professionals to efficiently calculate road-level distances between two locations with different vehicle profiles using the Log-hub Supply Chain Apps Distance Calculation service. The workflow incorporates an intelligent caching system to avoid recalculating previously processed distances, ensuring faster execution for large datasets.

Key Steps of the Workflow:

1.) Input Relation Data: The workflow begins by importing relation data (including sender and recipient addresses: Country, State, Zip, City, Street) from an Excel file. These address pairs are used as the input for distance calculation. Users must provide a valid Supply Chain Apps API Key, Workspace ID, and Scenario Name to enable the service.

2.) Caching Mechanism: A cache system (in the form of Excel or Parquet files) checks if the distance between the sender and recipient has already been calculated. If the distance is available in the cache, the value is retrieved, saving API requests and time.

3.) Distance Calculation: For new address pairs, the workflow sends the data to the Log-hub distance calculation service, which computes the road-level distance based on vehicle profiles (e.g., truck, car, etc.). The result is a highly accurate distance tailored to the selected profile.

4.) Handling Exceptions: A mechanism is in place to handle situations where the distance calculation fails or does not meet the desired quality. These problematic records are flagged for manual review, allowing the user to inspect and correct any issues with the data.

5.) Visualization and Storage: The calculated distances and associated geographic relations are visualized on a map, providing a clear and intuitive representation of the routes. The map is then saved on the Supply Chain Apps platform, allowing for easy access to the results for reporting and further analysis.

This workflow is tailored for professionals managing complex logistics networks where accurate distance data between various locations is essential. The caching system and exception handling improve efficiency, while the Log-hub API integration ensures high accuracy in distance measurements.



External resources

  • Supply Chain Apps API Key
  • Supply Chain Apps Distance Calculation
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 4.7.8
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.8

    knime
  • Go to item
    KNIME Data GenerationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Extension for Big Data File FormatsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.2

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME JSON-ProcessingTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.4

    knime
  • Go to item
    KNIME REST Client ExtensionTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.7.0

    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits