Rename a file after a Dynamic input tool

SWerbecki

Hello!

I'm feeding a dynamic input tool a file path that I am constructing with a formula tool.

I want to rename this file after I read it with the Dynamic input or at the end of the workflow.

For example:

File name: Mydata_07212025.txt

Rename to: Processed_Mydata_07212025.txt

Thank you!

Developer Tools

Accepted answers

abacon

@SWerbecki I would try this, just append the desired text in front of the filename field in a formula tool.

Bacon

All comments

abacon

@SWerbecki I would try this, just append the desired text in front of the filename field in a formula tool.

Bacon

HannahBrauer223

My first thought was to use a Block Until Done tool so that you can read back into the same file to give it a new name. However, since the name is changing, it won't find the original file but instead create a new file with the new name. Is that an option? Or you could add a row or column in the existing file that says "processed". My final thought it to use another RPA type software that checks to see if an output exists related to that file, then rename/move/delete the original file.

Hannah Brauer

Crowe LLP

jrlindem

If you're trying to rename the original source file, after it's read and pulled into your workflow:

The solution I would recommend is:

Read the file into your workflow
Use run command tool to rename and/or move the file
Optional: Use another run command tool even later in the workflow to remove or archive the original source file depending on your needs

Bottom line is you can use command prompt language via the run command tool to manipulate files on your computer!

SWerbecki

Thank you for the solutions!

Gaurav_Dhama_

You can read the file as normal, also import the file full path.
Towards the end of your workflow when you are writing an output, use a block until done and attach an append tool to its 2nd or 3rd anchor.
on source side of append tool, join the input tool file path. Ensure that you take out only one row, use unique or summarize or sample, that will be your choice.
After the append tool use the run command tool to rename the file.

This method will ensure that your whole process run successfully then only rename the file to processed.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167