- Hi -
I am attempting to use a variable in the file name to download files for the current day, but I’m having difficulty attempting to do this. I have created a variable, but using in the filemask from within an FTP File Activity is not working.
Here is the pseudo code for what I am trying to do:
- Initiate automation
- Create variable to retrieve ‘CurrentDate’
- connect to FTP and download filename + ‘CurrentDate’
- import data from all files into access database
- run some queries to create reporting
- export data to specific format
- Not sure if this is possible considering I will need powerpoint or some other file form
- email reporting
Please let me know if you need additional information or if this functionality is not available currently. I was under the impression that it would be available with the latest 3.5 release, but I’m unable to get it working.