Hi all,
I've seen some posts to rename a filename to include a date by using the Group By functionality in the Table tool. Unfortunately I need to use the Group By functionality to break out the file into separate tabs in Excel. Is there another way to both use the Group By functionality in the Table tool to break my data out into separate tabs within Excel and to rename the filename with today's date? I was able to figure out how to break out my data by a field but can't for the life of me figure out how to rename the filename with today's date.
This is the data:
I was able to render the data by breaking out the data by the "Aging Bucket" field into separate tabs within an Excel File. However, I need to have the filename changed from "Aging Report" to "Aging Report - 12/18/20". 12/18/20 would be Today's Date and would be dynamically changed whenever I Run the workflow.
I've attached my sample workflow. Thanks!
Solved! Go to Solution.
@ELPC
It seems that its possible to do this in Render tool.
Would you accept the normal excel output?
Thanks for the response but unfortunately I am trying to use the Render tool so that the column widths don't get collapsed so they show # signs and have to be manually expanded. I would really like a solution using Render. Thanks.
Thank you so much @christine_assaad ! That worked.
User | Count |
---|---|
17 | |
15 | |
15 | |
8 | |
6 |