Icon

Consolidation

🔍 Identifying Variances between data sets

🪡 This can be a literal "needle in the haystack" exercise

📊 Solving this in Excel may involve

➕ creation of helper columns
🔎 doing lookups

🚀 Let's explore an easier and repeatable way in KNIME!

📊 Data Consolidation

🔄 Consolidating Data

Bring together data from different files into the same table for seamless analysis

🗂️ Common Reporting Folder Structure (Shared Drive / SharePoint)

/Statements/<Country>/<Year>/File.xlsx

💡Challenge: How to do this efficiently

🤔 Apetite for more?

🚀 Let's explore some advanced workflow together!

📊➡️📧 Let's turn our insights into a report and distribute it via Email!

Path Configuration

Email Configuration

Send as PDF Attachment

Expression
Joiner
V1 Future
Excel Reader
Row Filter
Expression
Report Template Creator
Expression
Excel Reader
By Location
Profit Bridge
By Account
Profit Bridge
Concatenate
By Product Group
Profit Bridge
Path to String (Variable)
Identify Differences
Create Temp Folder
Report Concatenate
Transform to Flat File
Configure Email
Email Connector (Labs)
By Product
Profit Bridge
Enter Email Credentials
Credentials Configuration
Identify Differences
By Account
Profit Bridge
By Location
Profit Bridge
V1 Past
Excel Reader
Email Sender (Labs)
Excel Writer
V2 Recent
Excel Reader
By Product Group
Profit Bridge
By Product
Profit Bridge
Report PDF Writer
V1 Past
Excel Reader
Variable to Table Row
V2 Recent
Excel Reader
Excel Reader
V1 Future
Excel Reader
V1 Past
Excel Reader
V2 Recent
Excel Reader

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: marti
Created at: 2026-04-28
On NodePit since: 2026-05-08
Last update: 2026-05-08
Created with KNIME version: v5.8.3

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

Try NodePit Runner!