Icon

Read and Concatenation from multiple Excels to table

Your workflow goes here! :-) Get list of filesPath flow variable isalready present hereas it is the path of the current file being readThis creates Path and Sheetcolumn namesThis now creates flow variables:FilePathSheetSet Path, Sheet Name and Sheet Selectionfrom flow variables:FilePath,SheetSheetSelectionOptionEnd of "Sheet" with xlsx Loop Rename Path column to FilePathto avoid later confusion between"Path" variable already created in outer loopand a new "Path" variable that would be created by the "Table Row to Variable Loop Start"Set "SheetSelectionOption" flow variableto "NAME" in case Excel Reader option is getting set back to "FIRST"SNIPPET IS HERE PURELY FORDEMOREPLACE THIS SNIPPET WITH YOUR LOGICEnd of"File"Loop List Files/Folders Table Row ToVariable Loop Start Read ExcelSheet Names Table Row ToVariable Loop Start Excel Reader Loop End Column Rename String Manipulation(Variable) Java Snippet Loop End Your workflow goes here! :-) Get list of filesPath flow variable isalready present hereas it is the path of the current file being readThis creates Path and Sheetcolumn namesThis now creates flow variables:FilePathSheetSet Path, Sheet Name and Sheet Selectionfrom flow variables:FilePath,SheetSheetSelectionOptionEnd of "Sheet" with xlsx Loop Rename Path column to FilePathto avoid later confusion between"Path" variable already created in outer loopand a new "Path" variable that would be created by the "Table Row to Variable Loop Start"Set "SheetSelectionOption" flow variableto "NAME" in case Excel Reader option is getting set back to "FIRST"SNIPPET IS HERE PURELY FORDEMOREPLACE THIS SNIPPET WITH YOUR LOGICEnd of"File"LoopList Files/Folders Table Row ToVariable Loop Start Read ExcelSheet Names Table Row ToVariable Loop Start Excel Reader Loop End Column Rename String Manipulation(Variable) Java Snippet 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: z0025cak
Created at: 2021-05-07
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.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!