Hello All,
We have daily Input files copied into our shared drive out which I'm interested in bringing in the below two files for my workflow
File 1 = xxxxxxxxx_xxxxxx_-_xxxxx_xxxxxx_xxxxxxxx_xxxxx-xx-xx_2021-01-14xxxxxxxxxxx.xlsx
( This excel file has only one worksheet and it will be the same schema everyday.)
File 2 = xxxxxxx_xxxx_xxxx_xx_xxx-xx-xx_2021-01-14xxxxxxxxxxx.xlsx
(This excel file has multiple sheets and th schemas are different for each worksheet)
- Firstly I want to copy todays files from the shared directory to my local directory.
- Then I want to produce a log file saying the files copied are todays file.
- Then I want to make this dynamic so everyday when I run the workflow firstly it has to pick the above two files as of todays date and then copy from shared drive to local desktop folder..
Any thoughts on how to go about with this
