I used Directory + Sort + Sample to pull the latest file and now I want to make a copy of this file and rename it with yesterday's date in the same location. The excel file contains multiple sheets. If someone could help me on what tools next and the configuration, please. Thanks!
You can use this: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309
Then output to append the date as the name.