Combine Clean and Summarize Spreadsheet Data

Combine Clean and Summarize Spreadsheet Data

This workflow shows how to concatenate data from multiple Excel sheets and enrich the data with the value lookup function. At the end, it visualizes and aggregates the combined and cleaned data.

You can find more workflows and resources for spreadsheet users on the related collection page on the KNIME Community Hub.

Read three sheets from the same Excel file containing the following information:

• Furniture in the living room

• Furniture in the kitchen

• The estimated volumes of the furniture

Clean up the data by

• removing unnecessary columns

• shifting data that was entered into a wrong column

• changing the data type of a column

Combine data by

• concatenating rows in similar tables

• appending values from a dictionary

Calculate the following results:

• The volume by furniture type

• The total volume of all furniture

Task

The use case is calculating the total volume of the furniture when moving to a new apartment.