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 have come across a small problem while trying to get a specific workflow to run properly.
Basically all i want is to have the Alteryx Server (Private Gallery) pull a Template Excel File from a static source and just add one more Sheet onto it with alteryx.
I can easily do so if i write the file back somewhere, but i would also like the user running the workflow being able to download the File as a whole! (so far i only get to download the newly added sheet)
I want to have a pre-made Excel-File with all kind of fields that change depending on the data that is put out in the last added sheet by alteryx.
Since there are many formulas and designs in the Excel Template themselves i cant just have it all output by alteryx.
I have already tried including or not including it in the workflow data on the server, but i cant get it to work. Maybe someone here has come across a similar problem.
I have tried something like this, but as soon as i read and write the Template Excel File to Alteryx all design, formating and formulae within the template is lost. (Or maybe it is possible and i am just lacking the information how to keep this)
Basically i am looking for a way to give Alteryx a file without it needing to read it, just as a pass through to add another Sheet and supply the whole package to the user.