Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
I was asked by a client @brianvigus to help him put the current date onto a daily Excel output file. When they tried to prepend/append the date, it only would do so to the worksheet name and not to the workbook name. I do like the ability to update the table (worksheet) name and understand their desire to update the workbook name too.
My solution was to create a COMPLETE PATH\FILENAME|SHEETNAME data element and use the existing option to change the entire file path. That works.
I don't know if the solution to this idea is to update the help instructions to explain that table renames act differently than file renames or if the solution requires more functional options on append/prepend.