Alteryx Server

Find answers, ask questions, and share expertise about Alteryx Server.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

updating an existing Excel file on the C drive using Server

Highlighted
8 - Asteroid

Hello,

 

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?

 

 

Thanks,

 

Michael

 

Highlighted
Alteryx
Alteryx

Hi,

 

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.