This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
1. Update your Output Data path to refer to the full path of the Excel file (e.g., C:\users\matstecb\output_file.xlsx|||workingIndustrial). Make sure that the Run As user on Server has access to this file.
2. When saving the workflow to Gallery, click Manage Workflow Assets -> Uncheck output file
To DaveF's point - the reason this happens when migrated to the server is because Alteryx isn't actually creating anything other than the 1 tab you're telling it so, so in the context of the server, it doesn't have access to the original file, so its writing out to a new file that only contains the single sheet.
You might want to consider putting this file on a shared drive that both you and the server have access to so that the update can be done.
If this is a process that multiple people will use, you will run into file contention unless you do something to duplicate the file you're writing out to - think of this as a template. You can accomplish this using a .bat file that Alteryx executes when the workflow starts - it would essentially copy your template file to another location and write over that for the user, ensuring that the original template isnt destroyed and eliminating write contention (though this might not be necessary depending on your use case).
I am running in to same issue lately and i am unable to figure this out , Would it be possible to share an example gallery (analytic application ) for this so that i can use the file copy logic etc...
My issue is i am writing to a fixed tab in a pre-created(formatted with additional static tabs) excel file on my local machine, my solution works on my local machine as soon as i upload it to the gallery file format is lost