Icon

CalculatingOrdersLeadTime

O-list: Brazilian e-commerce - Calculating Lead Time for product delivery

Using an order dataset, shared on Kaggle by Olist, a Brazilian e-commerce, we will calculate the difference between (order confirmation date) and (delivery date).

Using the shared component **Diff Working Days** we will calculate the difference in working days considering the chosen weekly working days and a list of holidays.



Brazilian E-commerce Olist: Calculating Lead Time for product delivery dataset reference: https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce?select=olist_orders_dataset.csv HolidaysString to Dateorders_datasetselect delivered ordersdays to hours CSV Reader String to Date&Time Diff Working Days CSV Reader Row Filter Column Filter String to Date&Time Modify Time Math Formula Brazilian E-commerce Olist: Calculating Lead Time for product delivery dataset reference: https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce?select=olist_orders_dataset.csv HolidaysString to Dateorders_datasetselect delivered ordersdays to hours CSV Reader String to Date&Time Diff Working Days CSV Reader Row Filter Column Filter String to Date&Time Modify Time Math Formula

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: natan
Created at: 2022-12-19
On NodePit since: 2022-12-19
Last update: 2024-05-01
Created with KNIME version: v4.6.4
Tags: business daysworking daysworkdaysdate diffholidays

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

Try NodePit Runner!