This workflow saves the data from the 6 KPIs into a SQLite database.
Each KPI is computed in its dedicated workflow, which captures the computation of the KPI for all the available years.
HOW TO USE:
Select a year in which you want to compute the KPIs
Run the workflow executors, so that they compute the KPIs.
Save the year on the database. So if it's the first year (no tables are present) use DB writer to create the tables. If instead you want to append the tables to already existing ones (i.e., you are adding years) use DB insert nodes.
This database will be used in another workflow (6 KPIs Data App) to interactively display all the data.
Please note that the DB is directly saved in the 6 KPIs Data App "data" subfolder.
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter or botsin.space/@nodepit on Mastodon.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.