Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

how to rename an excel file ?

jm
5 - Atom

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! :)

2 REPLIES 2
ed_hayter
12 - Quasar

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.

 

image.png

 

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)

jm
5 - Atom

Option 1 worked :) thnx!  :)

Labels
Top Solution Authors