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.
Thanks,
Aaron
Solved! Go to Solution.
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).
That should work for powerpoint.
For Excel, won't that rename the "sheet" name, but not the actual file name?
For an Excel file, you can click the dropdown saying "Append Suffix to File/Table Name" and select "Change Entire File Path" instead.
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.
Cheers
Sean
Unfortunately, I'm on Alteryx 10.5 (with no way to update anytime soon) - is it possible to please upload one that is compatible with older versions? Or provide screenshots of your method?
Hey @Sharbucks
The version issue is a common challenge that people face and the solution is easy.
Open up the Alteryx file in Notepad ++ or your favourite text editor
Then change the version number in line 2 or 3
Save
Done
:-)
This post should help:
Thank you - this helped!
Any chance there's a way to name PDF reports output from Alteryx dynamically based on a field as well? In reviewing the options within the Render tool nothing jumps out at me.
I would also be interested in this...any luck?