Icon

Build a no code dashboard

import Vendor MasterData
Excel Reader
Import monthly budget list
CSV Reader
Sum Actualsper Vendor
GroupBy
Connect to PO Database
SQLite Connector
choose Purchase Orders Table
DB Table Selector
Read in actual PO data
DB Reader
enrich PO data with Vendor information
Joiner
only top 10vendors
Top k Row Filter
create Fiscal Year Month
Expression
Join in preferred vendor status
Joiner
convert Order Dateto datatype 'date'
String to Date&Time
add the budgetsto the aggregation
Joiner
extract Year and Month fromOrder Date
Date&Time Part Extractor
aggregate spendby Category andFiscal Year Month
GroupBy
replace the dashwith "/" in Month
Expression
top: User Selection Categorymiddle: actuals vs budgetbottom: vendor data
Dashboard
extract Categoryas Set for filtering
GroupBy
convert Categoryset to variable
Table Row to Variable

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: User
Created at: 2026-09-08
On NodePit since: 2026-09-15
Last update: 2026-09-16
Created with KNIME version: v5.8.1

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

Try NodePit Runner!