Icon

1. Projects

KBL: Preparing Data for Report
Workflow: Projects In this workflow we prepare data to be displayedin a report.Starting from the accounting of a list of projects,on one branch we calculate the money in budgetfor each year for each one of the project and onthe other branch we calculate the money actuallyspent for each project each year.We then report the money allocated, the moneyspent and the money remaining for each projecteach year. Calculating money spent for each project each year Calculating money in budget for each project each year money by project by yearrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"by RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDremain 2009remain 2008remain 2007remain 2009remain 2008remain 2007Node 31used moneyratio w. resp.2007Projects.txt filewith path relative to"current workflow"inner join on RowIDs GroupBy Column Rename Column Rename Sorter Sorter Pivoting Pivoting RowID RowID Unpivoting ConstantValue Column Math Formula Math Formula Math Formula Java Snippet Java Snippet Java Snippet Java Snippet(simple) Math Formula(Multi Column) CSV Reader Joiner Workflow: Projects In this workflow we prepare data to be displayedin a report.Starting from the accounting of a list of projects,on one branch we calculate the money in budgetfor each year for each one of the project and onthe other branch we calculate the money actuallyspent for each project each year.We then report the money allocated, the moneyspent and the money remaining for each projecteach year. Calculating money spent for each project each year Calculating money in budget for each project each year money by project by yearrenaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"by RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDremain 2009remain 2008remain 2007remain 2009remain 2008remain 2007Node 31used moneyratio w. resp.2007Projects.txt filewith path relative to"current workflow"inner join on RowIDsGroupBy Column Rename Column Rename Sorter Sorter Pivoting Pivoting RowID RowID Unpivoting ConstantValue Column Math Formula Math Formula Math Formula Java Snippet Java Snippet Java Snippet Java Snippet(simple) Math Formula(Multi Column) CSV Reader Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2022-05-04
Last update: 2024-11-17
Created with KNIME version: v4.4.0
Tags: EducationKNIMEPressPivotingMath formulaAggregation

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

Try NodePit Runner!