Icon

loop demo

Workflow Control - Solution

Solution to exercise 11 for the KNIME Analytics Platform for Data Wranglers course
- Write subsets of a file using a loop
- Read and concatenate many files using a loop
- Activate a workflow branch based on a user selection

Loop demo: Concatenate Multiple Excel SheetsGoal: Create a loop that reads and concatenates all the sheets in an Excel file. - Create a table that contains all sheet names (Read Excel Sheet Names node) - Start a loop that iterates over the sheet names (Table Row to Variable Loop Start node) - Read the Excel sheet with the sheet name in the current iteration (Excel Reader node) Tip: Use the flow variable created by the Table Row to Variable Loop node to control the setting sheet_name in the FlowVariable tab - Close the loop and concatenate the tables from the different iterations (Loop End node) Create table withall sheet namesRead one sheet perinterationLoop overall sheet namesCombine all sheetsinto single table Read ExcelSheet Names Excel Reader Table Row ToVariable Loop Start Loop End Loop demo: Concatenate Multiple Excel SheetsGoal: Create a loop that reads and concatenates all the sheets in an Excel file. - Create a table that contains all sheet names (Read Excel Sheet Names node) - Start a loop that iterates over the sheet names (Table Row to Variable Loop Start node) - Read the Excel sheet with the sheet name in the current iteration (Excel Reader node) Tip: Use the flow variable created by the Table Row to Variable Loop node to control the setting sheet_name in the FlowVariable tab - Close the loop and concatenate the tables from the different iterations (Loop End node) Create table withall sheet namesRead one sheet perinterationLoop overall sheet namesCombine all sheetsinto single table Read ExcelSheet Names Excel Reader Table Row ToVariable Loop Start Loop End

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: knime
Created at: 2014-06-17
On NodePit since: 2023-01-25
Last update: 2024-05-01
Created with KNIME version: v4.7.0
Tags: loopreading many filesswitchalternative branchworkflow controleducation

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

Try NodePit Runner!