Icon

Demo_​solution

Node 2368Sort data on business cases:by dkey, by scaled quantity and by datemake previous price columnMake previous quantity columneliminate values from condition rate (-1) cells with previous scaled quantities that do not match the current scaled quantityCalc amount diff btw curent and previous price for each scaled quantityCalc % diff btw curent and previous price for each scaled quantityBring back to initial sortingExcel Reader (XLS) Sorter Lag Column Lag Column Rule Engine Math Formula Math Formula Sorter Node 2368Sort data on business cases:by dkey, by scaled quantity and by datemake previous price columnMake previous quantity columneliminate values from condition rate (-1) cells with previous scaled quantities that do not match the current scaled quantityCalc amount diff btw curent and previous price for each scaled quantityCalc % diff btw curent and previous price for each scaled quantityBring back to initial sortingExcel Reader (XLS) Sorter Lag Column Lag Column Rule Engine Math Formula Math Formula Sorter

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: zugravu.e
Created at: 2022-02-20
On NodePit since: 2022-02-23
Last update: 2024-11-24
Created with KNIME version: v4.2.5

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

Try NodePit Runner!