Icon

Read Files and append columns

There has been no title set for this workflow's metadata.

This is a KNIME Workflow example for a user's question based on a YouTube video. You can find the video (and the users comment / question) in the links below.

This workflow basically loops through a list of files, reads them and appends the new columns to the right by using the Loop End (Column Append) node.

The Table Row to Variable node is used to turn the file location into a dynamic Flow Variable so the workflow would also work, no matter if it is 1, 10 or 100 files to be read.

URL: KNIME Tutorial Video Link (KNIME User Interface) with User Comment https://www.youtube.com/watch?v=kPrfEXZGuzE
URL: My Bytes&Budgets KNIME YouTube channel https://www.youtube.com/@bytesandbudgets?sub_confirmation=1

Point to your folder containing yoursource files here: read partialsource filesloop throughfile listnext iterationturn file nameinto flow variableread file ofcurrent loop iteration fromflow variable List Files/Folders Chunk Loop Start Loop End (ColumnAppend) Table Rowto Variable Excel Reader Point to your folder containing yoursource files here: read partialsource filesloop throughfile listnext iterationturn file nameinto flow variableread file ofcurrent loop iteration fromflow variableList Files/Folders Chunk Loop Start Loop End (ColumnAppend) Table Rowto Variable Excel Reader

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: m1pegv
Created at: 2024-11-08
On NodePit since: 2024-11-08
Last update: 2024-11-21
Created with KNIME version: v5.2.0
Tags: ETLYouTubedata transformationcolumn append

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

Try NodePit Runner!