Automatic File Name Change

[JamesPorter]

Hi all,

Trying to use a formula tool to automatically write the filename and date/time into each, but for each time where a specified field changes (in this instance plant) I want that to then change to a new file.. i.e. so if plant a then b then c I want separate output files, without creating 3 different outputs on the workflow. I can get it to work with csv but not xlsx file output..

Screenshots attached

Thank you in advance

[alexnajm · Accepted solution]

Your configuration will only change the sheet name - you'll have to create the entire path in a Formula tool before the Output Data tool, change the output option to "Change Entire File Path" and reference that newly created field

[JamesPorter]

Perfect, thank you.