Icon

Export to Tableau - KNIME Forum (91775)

<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) https://www.knime.com/knimepress/beginners-luck
URL: KNIME Forum (91775) https://forum.knime.com/t/database-file-is-locked-by-another-process-error/91775/2?u=mlauber71
URL: Medium: KNIME — Cases, Switches and Catching Errors https://medium.com/low-code-for-advanced-data-science/knime-cases-switches-and-catching-errors-5ab748cbeaa3

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

Make sure the .hyper file is being deleted

Medium: KNIME — Cases, Switches and Catching Errors

https://medium.com/p/5ab748cbeaa3

tableau_file
Create File/Folder Variables
Renaming "<year>+Sum(...)" into just "used <year>"
Column Renamer
Merge Variables
Money assigned to project each year
Pivot
tableau_file_location
Path to String (Variable)
Try (Variable Ports)
Catch Errors (Var Ports)
Inner joinon RowIDs
Joiner
Renaming "<year>+Sum(...)" into just "assigned <year>"
Column Renamer
Money used byproject each year
Pivot
MoneyTable.hyperseems not to support thePath Variable type
Tableau Writer
Projects.txt
CSV Reader
Calculate remainingmoney for each year
Expression
Delete Files/Folders

Nodes

Extensions

Links