Dynamically rename output files with the Table/Render tool

[P_Schenk]

Hi everyone,

One of the great features of the Output tool is the option to take a file name from a field.

In order to update the filename, you select the option "Change entire file path".

I would like to combine this option with the Table/Render tool and format my data before I turn it into an Excel file.

However, I can't seem to find the "Change entire file path" option or something alike in the Render tool.

Does anyone have a solution for this?

Thanks in advance.

[LordNeilLord · Accepted solution]

Hey @P_Schenk

In the render tool you can use the function "Group Data into separate reports" in which you can use the option "replacing entire path with group"

 

[P_Schenk]

Thank you so much LordNeilLord!!!

Originally I had no field to group on but thanks to your comment and printscreen I was able to succeed.

[newuser980345483]

Are you able to hide the filepath from the table when you output this? 

[Uli123]

Yes, the filepath will not show within the table once it is outputted from the render tool.

[zhussain]

I'm not able to upload using a long network path.  Any suggestions?

[PeteLacz]

What if we want to have multiple tabs within the workbook?