Consolidation of file within a static folder

Question

Hi All,

Please help. I am working on a small project and below is my requirement.

1. Static folder created as onetime

2. Every month a standard layout file will be hosted into that folder

3. Once the file is loaded, I will run the workflow for consolidation, which was already created

4. Right now consolidation is done independently by using the input tool for each file, however, that will make the workflow clumsy over a period of time.

The requirement is to read the files in the folder without adding them every time through the input tool.

Thanks
Naga

messi007 · Accepted Answer

@Naga,

You can use read directory and the dynamique input in order to read all the files

Attached the workflow you have to update the folder path and the sheet name in the formula tool.

Hope this helps!

Regards,

messi007 · Accepted Answer

@Naga,

You can add a file name as a column for each file by selecting the option below on the dynamic read tool:

Hope this helps!

Regards