how to rename an excel file ?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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! :)
- Labels:
- Python
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Option 1 worked :) thnx! :)
