Icon

Biosolutions Global Supply Chain

Data Cleaning
Data Transformation - Add Year & Month Data
Access the Sales Data
from a Database
Access the Logistic Data
from a Database
Data Transformation - Add Geometric Lines to Delivery Routes
Data Transformation - Completed Delivery Trips with Origin & Destination Countries and Geometric Lines
Visualization & Reporting
Visualization & Reporting
Data Transformation - Completed Orders with Location and Product Info
Filter out missing or 0 Sales Order Amount
Row Filter
Routes
DB Table Selector
Visualization - Logistic
Remove duplicatebased on Sales Order ID
Duplicate Row Filter
DB Reader
Map origin_country = 1, destination_country = 2
Expression
Products
DB Table Selector
Append origin & destination countries and geometric lines
Joiner
Filter completed orders
Row Filter
DB Reader
Report PDF Writer
Natural Earth Global Data
Sales Orders
DB Table Selector
Sales Order Items
DB Table Selector
Report Template Creator
Report Template Creator
DB Reader
DB Reader
Append list of products for each order
Joiner
Report PDF Writer
DB Reader
DB Reader
Append product categories
Joiner
Append sales location
Joiner
Visualization - Sales
Data type cast for sales order time
String to Date&Time
Add root categories
Expression
Add parent categories
Expression
Combine origin & destination countries into single column
Unpivot
Get the centroid point
Geometry To Point
Append geometry data
Joiner
Add yyyy-MM data
Date&Time to String
Customers
DB Table Selector
Create lines between origin & destination countries
Points To Line
Trips
DB Table Selector
Row Filter
SQLite Connector
Rename the new column into year_month
Column Renamer
Append geometric lines
Joiner

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: Irene Havsa
Created at: 2026-04-13
On NodePit since: 2026-04-15
Last update: 2026-04-15
Created with KNIME version: v5.11.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!