Icon

Dashboard as Data App

import Vendor MasterData
Excel Reader
Import monthly budget list
CSV Reader
Sum Actualsper Vendor
GroupBy
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
Read the Purchase Ordersline items
CSV Reader
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-24
Last update: 2026-10-12
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!