Latest updated file selection

Automation Studio
1
  1. I have a scenario where I need to search for a particular file from a defined location

there will be files with names like below

customers.xlsx
customers-copy.xlsx
customers-copy(2).xlsx

these files are created as an output of another process.

I need to get the latest created file.

  1. can we give a dynamic file name in an excel loop activity.

kindly help if there is any solution for these two.

2

Hi,

  1. When you do File Search operation then in output excel you get created date and modified date for each file. You can get the name of last created or modified file from the out put search result excel generated using File Search activity
  2. Yes, you can give dynamic file name in excel loop activity. First create the process using one file. Then replace excel file location with an argument which will hold the file path

Regards,
Amit Anand

3

Ok I will try that thank you