Icon

2. Preparing Data for a Report_​final

<p><strong>Preparing Data for a Report</strong></p><p>In this workflow we prepare data to be displayed in a report.</p><p>Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year.</p><p>We then report the <em>money allocated</em>, the <em>money spent</em> and the <em>money remaining</em> for each project each year.</p>

URL: KNIME Beginner's Luck (Book Homepage) https://www.knime.com/knimepress/beginners-luck

Workflow: Preparing Data for a Report


In this workflow we prepare data to be displayed in a report.

Starting from the accounting of a list of projects, on one branch we calculate the money in budget for each year for each one of the project and on the other branch we calculate the money actually spent for each project each year.

We then report the money allocated, the money spent and the money remaining for each project each year.

Calculating money spent for each project each year

Calculating money in budget for each project each year

Reading data

Calculating remaining money for each year

Money assigned to project each year
Pivot
Money used byproject each year
Pivot
Set project names as RowIDs
RowID
Renaming "<year>+Sum(...)" into just "used <year>"
Column Renamer
Renaming "<year>+Sum(...)" into just "assigned <year>"
Column Renamer
Set project names as RowIDs
RowID
Projects.txt
CSV Reader
Inner joinon RowIDs
Joiner
Ascendingby RowID
Sorter
Calculate remainingmoney for each year
Expression
Ascendingby RowID
Sorter
Constant Value Column Appender

Nodes

Extensions

Links