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.
New to Alteryx, and not exactly sure where to post this. I have a workflow that gives me a report in Excel, as well as a Powerpoint file. I was wondering if there was a way to rename the files as they are output.
Yes indeed. In the Config Panel for the output tool, towards the bottom, you will see options for supplying the name of your output using a column. Thus, just before the output tool, you could place a Formula tool where you create a new column called "OutputFileName" (or whatever you want to call it)... then supply whatever you want right there... (you could even base it off of the values of other variables in your data set, should you so desire).
Here's an example - where the file name & sheet name is coming from the workflow. This not only writes to 2 different excel files, but in workbook A it also creates and writes to 2 different sheets. I've put a standard export to excel; and a dynamic version (which dynamically creates the filename) on the same workflow so that you can see the differences.
The trick is, like John said, to use the "Change entire file path". Create a formula field which creates a full filename (excel file | sheet name), and then use this on the output.
Have a look - if this solves your problem, please could you mark this as solved, or if you still have questions, please feel free to reply and we can work together to get you to the solution you need.