Hi all
I am trying to build a workflow which dynamically pulls a file from a folder that contains copies of the same file which are updated daily, with the date appended to the end of the file name for each new file. I am attempting to pull the latest file and believe I have figured that part out (although any advice would be appreciated in terms of automating that process for a daily basis), but the new issue I am running into is that the files are password protected and that seems to be an issue for the dynamic input tool. All of the passwords are the same for every daily rendition of the file. Any advice would be greatly appreciated!
Solved! Go to Solution.
@felixlam refer this
this should help.
How To: Read/Extract password protected Excel file using R Code in Alteryx Designer
@Raj thank you!