Reading all sheets of all files in a folder and create a formatted output with multiple sheets

[mlauber71]

@Lorin

use the Local File System

You can dynamically extract the local path and create new path variables.

Collect Local Metadata – mlauber71

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]