Sheet name prefix/suffix

[Pkumar196]

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. 

[binuacs · Accepted solution]

@Pkumar196 The append Suffix/prefix option available in the output tool

[Pkumar196]

@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.

[DataNath · Accepted solution]

@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:

[Pkumar196]

@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.