Icon

00_​Your_​First_​Workflow_​Solution

1. Read the following sheets of theHouse_items.xlsx file:- Kitchen- Living Room 2a. Concatenate the data from the two sheetstogether2b. Remove the Notes column 3. Show the total amount by item in a bar chart 4. Read the Items_volume.xlsx file 5. Replace the missing values in the Volumecolumn with the values in the empty_Ccolumn 6. Append the item volumes to thetable 7. Show the total number of itemsand total volume KitchenLiving roomRead volumesReplacemissing valuevolume as stringnumber of itemsInsert volumestotal volumeand amount Excel Reader Excel Reader Concatenate Column Filter Excel Reader Column Merger String To Number Bar Chart (Labs) Cell Replacer Statistics (Labs) 1. Read the following sheets of theHouse_items.xlsx file:- Kitchen- Living Room 2a. Concatenate the data from the two sheetstogether2b. Remove the Notes column 3. Show the total amount by item in a bar chart 4. Read the Items_volume.xlsx file 5. Replace the missing values in the Volumecolumn with the values in the empty_Ccolumn 6. Append the item volumes to thetable 7. Show the total number of itemsand total volume KitchenLiving roomRead volumesReplacemissing valuevolume as stringnumber of itemsInsert volumestotal volumeand amount Excel Reader Excel Reader Concatenate Column Filter Excel Reader Column Merger String To Number Bar Chart (Labs) Cell Replacer Statistics (Labs)

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-03-08
On NodePit since: 2023-04-05
Last update: 2024-09-20
Created with KNIME version: v4.7.2

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

Try NodePit Runner!