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.
I had a look at your Output tool configuration and it looks like you have it configured to only output Sheet1.
The reason why you find the template1 sheet in your local file when you run the workflow, is probably due to the fact that it was already there in the file (it's not actually the workflow to produce it). The option 3. Output Options in your Output tools set to Overwrite Sheet (Drop) makes this transparent to you.
Try if this article on how to write to multiple Excel sheets helps you:
Thanks a lot for trying to help me, but it is not what I need 😞 Yes, I know that I produce only Sheet1, but template1 sheet needs to be all the time the same included in the output. Template1 sheet is not included in any workflow.
Let me please know if I am still unclear of what I need.
The idea is that you can package your output (containing the template1 sheet already) together with the workflow, so that every time you run it, only Sheet1 gets replaced by the workflow, while Template1 sheett is already there.
I managed to replicate your issue and, thanks to @MichalM, I now understand why Gallery behaves this way.
Although you packaged your output file with the workflow as an asset, every time that you run the app on Gallery, a new folder on Server is created containing temprorary files needed to execute the workflow. With the current configuration of the Output tool, a new Test_Output_2.xlsx file is created in that folder, hence it cannot contain the template1 sheet.
In order to get what you want, I can recommend 2 options, depending on your use case:
1) set up the Output tool to write to an absolute location (can be a shared folder on the Server or anywhere else on your network). Check workflow dependencies (Options -> Advanced Options -> Workflow Dependencies) to make sure you have an absolute reference there on the output.
2) have the template1 sheet as an extra input in your workflow and append it to the output
Option 1 could be potentially more straightforward, but if you have multiple users to run the app at the same time, you run the risk of writing twice to the same file and, potentially, getting errors.
Option 2 is a safer from this point of you, it may cost you a little bit on the automation side of things, depending on how 'dynamic' your template1 sheet is.
You can see if the server contains your file by downloading it from your private gallery and opening the yxzp in Alteryx. If it has your template file, it will display that when you open the yxzp in Alteryx.