how to rename an excel file ?

Question

Hello, this is my first time building an auto with Alteryx and need some assistance! I need to know which activity i can use to rename an excel file that is in my downloads folder in my share drive. For example right now the file name is EPIC 2.0 - Quality Summary Report, and after alteryx runs and completes all its filters, i want alteryx to rename the file to Quality Summary Report_CB_

I simply want to rename the file itself, NOT the contents within the excel. I have been told different options to use, such as python, the output tool, the dynamic rename tool, but I'm not sure which one of these, if any, can help me. please advise, TY! :)

jm · Answer

Option 1 worked :)  thnx!  :)

ed_hayter · Answer

I am a bit confused by the request - you have an excel and you make changes to it - if you want to rename the file after changes then an output tool with a new file name (and potential location will work).

If you want to rename the file in shared downloads without any changes (the filtering or whatever) I would then have a seperate branch renaming the file to XXX_Process_run along with your New_file_output file.

Depending on file size option 2 might need a block until done as you cannot start writing back to the file until all the data is inputted (Alteryx reads in the data in batches I believe for performance reasons)

rename file flow.yxzp