Parallel-process multiple Excel files by sheet name in a single KNIME workflow

[mlauber71]

@san_98 from what I recall we had a similar thread about parallel processes

Parallel Processing of Multiple Excel Files Based on Dynamic Sheet Names from List Files/Folders Node in KNIME

@san_98 In your screenshot I do not see any Parallel Chunks and no database access, but if you are fine we are fine For the fun of it I expanded on @MartinDDDD workflow and constructed a parallel access with a database node calling sub-workflow(s) that would then use this connection. So far it seems to work although any benefits in speed might depend heavily on the actual database(-connetion) supporting parallel access. [image] The callee workflow does look like this: [image…

Maybe you can combine it with these information

Create individual excel files from multiple worksheets

@lazaronewhall17 yes this can be done. With such tasks you can combine several nodes into a system to handle your files. [image] You read the Excel Sheet names and feed them into a Table Row to Variable Loop start to iterate over them (you can expand this obviously to several files). You create Path variables for a new sub-folder: [image] Using the name of the “Sheet” as Folder name from the Flow Variable (you can use other things too, or you can just skip this part): [image] You then c…