Consolidation of file within a static folder

[Naga]

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 solution]

@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,

[Naga]

Thanks @messi007 

This helped, but one thing required is the field to identify the different files that loaded to the consolidated file, like the file name column appended to each file.

Thanks
Naga

[messi007 · Accepted solution]

@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