Rename Filename on appending report from Workbench
Weekly I am appending the reports using workbench. I want to rename the Filename column into week number so that I could use this for my Week Over Week analysis. For example: my report names are "Jan 10", "Jan 17" and so on and Filename column generated as C\:work\Jan 10.xlsx. I want this filename to be look like "Jan 10", "Jan 17" and so on.
Could you please suggest how can we do that. Attached is a screen shot.
Thanks for your help!