Icon

Export to Tableau

<p><strong>Export to Tableau</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. We then export the prepared data to be displayed in a Tableau report.</p>

URL: KNIME Beginner's Luck (Book Homepage) http://Data with row ID as a column

Workflow: Export to Tableau


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 export the prepared data to be displayed in a Tableau report.

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

Export prepared data to Tableau

Renaming "<year>+Sum(...)" into just "used <year>"
Column Renamer
Money assigned to project each year
Pivot
Inner joinon RowIDs
Joiner
Renaming "<year>+Sum(...)" into just "assigned <year>"
Column Renamer
Money used byproject each year
Pivot
MoneyTable.hyper
Tableau Writer
Projects.txt
CSV Reader
Calculate remainingmoney for each year
Expression

Nodes

Extensions

Links