How can i move excel files from one folder to another using alteryx? Is there any tool, method or sample workflow? Please help !!!!
@arsh011
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Copy-Excel-File-and-Move-to-Folder/td-p/998617#:~:text=Using%20a%20formula%20tool%2C%20create,want%20the%20files%20moved%20to.&text=This%20should%20then%20move%20the%20files%20from%20one%20folder%20to%20another.
I tried the blob tools method but it gives an error "Access is denied". How can i handle this error , system already has the access.
What is the path that you used for the Blob Input tool?
Fullpath from directory tool.
Are you running it from Designer or from a Server?
Currently in Designer but need to test on server as well.
The Blob solution works fine for me, how did you configure the Blob input and output?
In Blob input - Replace Entire path with Field ->> Fullpath
In Blob output - Replace Entire path with Field ->> Targetpath
Do you have access with writing rights for the both folders?
yes
Access is denied means either :
1) your path is wrong.
2) you do not have access to your path
3) your Alteryx should be run in admin (which has access to the path) but you are running in non elevated.
4) in some cases the file may be open by you or another user in another system. If this is causing that issue - you must force close the file first.
This is pretty straight forward messaging
