Hi @nadiahnoorlin ,
You can use a Directory tool that will point to a certain path in your system and look for files of a particular type.
Once you run the workflow, that tool will return to you a list of all the files in that directory. One of the available columns would be [Creation Time] and if the file was created yesterday you can implement a logic that would dynamically keep only records that have been created yesterday.
If the file date is also contained in the name, then you can parse the [Filename] column to extract the date and then similarly to above, implement a logic with a filter tool to only keep records that have been created yesterday.
Finally, if your different files have the same schema, you can use a dynamic input tool to read all of them in Designer. Otherwise, you would have to create a batch macro.
Hope that helps,
Angelos
