Sheet name prefix/suffix
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Community,
I am looking for a solution where I can add a specific prefix/suffix in all sheet names as well as in file name and then convert it into an analytic app. Can anyone provide a suggestions/solution for the same.
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thanks for the solution. It has solved my query partially. I tried the solution it has updated my sheets name. In addition to sheet name I want to update my file name as well with the same keyword. Could you please help me with the same. For example my current output file name is ABC_DIM0196057_Report with sheet name DIM0196057 Monthly Report and DIM0196057 Quarterly Report but next time when I will run the file I want my file name to be ABC_DIM0265457_Report with sheet name DIM0265457 Monthly Report and DIM0265457 Quarterly Report.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Pkumar196 would this approach work for you? You build the entire filepath up using the fields that your suffix and names of your sheets will come from and then in your 'Output Data' tool, replace the entire filepath with this. Have attached an example workflow:
Building custom filepath with the suffix in file and sheet name:
Configuration of Output Data tool, with 'Overwrite Sheet or Range' selected and changing the entire filepath using the field containing the custom path:
Output, with the custom '999' suffix in both file and sheet names:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DataNath Thanks for the solution. It does resolve my query. In addition to it just wanted to check if it is possible to generate output in an existing file with multiple tabs already there with the same configuration for name update as per your resolution. I was able to do it using append/prepend suffix in output configuration and selecting the existing file for saving location. But since we are using change entire path not sure how to do it.
