Icon

00_​Combine_​Clean_​and_​Summarize_​Spreadsheet_​Data

Combine clean and summarize data from spreadsheets

In this exercise, you'll learn how to read, combine, clean, and summarize data from multiple Excel sheets. You'll calculate the total volume of a cargo that carries furniture from one house to another.

Replace missing values in the "Dict-Volume" column with the valuesavailable in the "empty_C" column
Column Merger
Read the first sheet ("Kitchen")of the rooms.xlsx file
Excel Reader
Read the "Living Room" sheetof the rooms.xlsx file
Excel Reader
Bring the items in the "Kitchen" and "Living Room"in one table
Concatenate
Append the volumesof the listed itemsbased on their IDs
Value Lookup
1st output port: Sum up volumes of the listed items.2nd output port: Calculate the grand total volumeof all items.
Row Aggregator
Change "Dict-Volume"columnfrom string to number
String to Number
Read the "Dictionary" sheetof the rooms.xlsx file
Excel Reader
A Bar Chart with the amounts of single itemsin the cargo
Bar Chart
Exclude the commentsfrom the "Living Room" sheet
Column Filter

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: Emilio.Silvestri
Created at: 2023-02-17
On NodePit since: 2026-03-17
Last update: 2026-03-17
Created with KNIME version: v5.11.0
Tags: SpreadsheetBeginnersOnboarding

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

Try NodePit Runner!