Consolidate Multiple Excel Files into one -

[mlauber71]

@Bewaji2 here you can see how to create a Path variable:

Write multiple CSV file to a loop

@VJAM the creation of Flow Variables for Paths is maybe not 100% straightforward. Maybe this example might help to sort it out. The “path_values” is maybe not perfectly named. I think this is constructed that you could pass several Folder variables as collection strings. Also: CHunk Loop Start might have to be set to 1. Often I prefer the Table Row to Variable Loop Start node. [image] [image]

Also you could check out the “KNIME File Handling Guide” (yes it is long but maybe worth it )

https://docs.knime.com/latest/analytics_platform_file_handling_guide/index.html#introduction