Icon

Calculation Logic with Several Conditions

promo 1create 4 marked groups in each monthremove line breakin column namesget date rangesfor different itemsadd the qty soldeach dayjoin promo 1 data with4 marked groupsjoin promo 2 datapromo 2add the qty soldeach dayadd qty sold for no promo to every day (this is not ideal)resolve overlap in final_value columnX days of promo * qty soldExcel Reader Create Date&TimeRange Create Markersfor Months Column Rename(Regex) Table Rowto Variable String Manipulation Joiner Joiner Create Date&TimeRange String Manipulation String Manipulation Rule Engine GroupBy promo 1create 4 marked groups in each monthremove line breakin column namesget date rangesfor different itemsadd the qty soldeach dayjoin promo 1 data with4 marked groupsjoin promo 2 datapromo 2add the qty soldeach dayadd qty sold for no promo to every day (this is not ideal)resolve overlap in final_value columnX days of promo * qty soldExcel Reader Create Date&TimeRange Create Markersfor Months Column Rename(Regex) Table Rowto Variable String Manipulation Joiner Joiner Create Date&TimeRange String Manipulation String Manipulation Rule Engine GroupBy

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: victorpalacios
Created at: 2022-08-02
On NodePit since: 2022-08-03
Last update: 2024-05-01
Created with KNIME version: v4.5.2

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

Try NodePit Runner!