Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

updating an existing Excel file on the C drive using Server

8 - Asteroid



I created a workflow which updates an existing Excel file using Designer.    The name of the excel file is read from an input and I am using the Change Entire File Path in the output tool.


How do I move this to hosted Gallery (not on-premise).  It seems that I need to attach the excel file to the workflow which would not be dynamic.   I was able to get this to work by making the excel file an asset.


If I have Gallery running on-premise then would I have access to local/network drives when using Gallery to update existing excel files?










To make the input of the workflow dynamic you can use interface tools to choose the file you want to work on at run time. Since your server is on a remote host you will not be able to modify files on your local PC but you could modify files on a shared drive or another solution like OneDrive and the OneDrive connectors, I've tried this out before and it worked for me. If the file is shared and Server can read/write to that folder you can work with those files.