Hi everyone, I am kind of stuck on a problem where I have to output excel files based on user selection of folders.
Basically if user selects folder 1 and 2 there will be two files one for folder 1 and one for folder 2. now the selections are working fine but I am getting output in a join tool and using a dynamic input tool to render it and because of which I am getting the output in one single file while what I want it completely different.
Current Setup:
- The workflow allows users to select subdirectories dynamically.
- A Dynamic Input Tool is used to read files from the selected subdirectories.
- The files inside each subdirectory are merged together.
- An Output Data Tool saves the final output.
Issues I’m Facing:
1️⃣ All data is merging into a single output file instead of creating separate files for each subdirectory.
2️⃣ The full file path (or file name) is lost when using the Dynamic Input Tool, so I can’t track which data came from which file.
3️⃣ The output files are not being saved separately, meaning everything is combined into one instead of distinct files for each subdirectory.
What I Need:
✔ Each subdirectory should have its own separate output file.
✔ Files inside a subdirectory should be merged, but not merged across different subdirectories.
✔ The original file names (or full paths) should be retained in the output.
✔ The Output Data Tool should save separate files instead of merging everything into one.
