Icon

01 - Looping through files

Looping through a list of Excel files

The idea of this workflow is to demonstrate how useful Loop Nodes in KNIME are.

You read a list of file(paths) and then iterate over them one by one, using the Chunk Loop Start Node.

Within the loop the path is converted into a variable and then fed into an Excel Reader.

This workflow goes along with my weekly newsletter aboud data analytics called "The Data Alchemist", click on the link below to find out more or subscribe for free.

Please note that the List Files / Folders node uses a "relative" filepath to list the files in a folder (so the sourcefiles could be shared with this workflow together) get the listof PVO filesfrom a folderloop throughthe list of Excel files1 by 1convert the pathinto a variable sowe can feed it intothe Excel Readerread oneExcel fileper loopiterationgo back to theChunk Loop startuntil no more pathsare available List Files/Folders Chunk Loop Start Table Rowto Variable Excel Reader Loop End Please note that the List Files / Folders node uses a "relative" filepath to list the files in a folder (so the sourcefiles could be shared with this workflow together) get the listof PVO filesfrom a folderloop throughthe list of Excel files1 by 1convert the pathinto a variable sowe can feed it intothe Excel Readerread oneExcel fileper loopiterationgo back to theChunk Loop startuntil no more pathsare availableList Files/Folders Chunk Loop Start Table Rowto Variable Excel Reader 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: philk
Created at: 2023-10-14
On NodePit since: 2023-10-15
Last update: 2024-05-01
Created with KNIME version: v4.7.7
Tags: looploopingExcelspreadsheets

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

Try NodePit Runner!