Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Using Excel template files for data output in Server

HM17
5 - Atom

I have set up some workflows which make use of .bat files in order to take a copy of a template Excel file which contains pivot tables and formatting and paste it to a new location with a reporting period as a suffix to the file name, the workflow will the output data to this file.

 

This works great in Designer, but when attempting to run in Server, the .bat file will not run. 

 

 "The external program "Runthis.bat" returned an error code: 1 (ToolId: 11)"

 

Is there a solution to this, or are .bat files not compatible with Server? If this is the case, are there any other methods to write to a renamed template file, other than the end user manually creating the file prior to running the workflow?

 

Thanks

1 REPLY 1
HM17
5 - Atom