Change File Name

I have a simple request to change file a.xlsx to b.xlsx. As the original file has formatted data and merged data, if I read the file from a.xlsx and output is as b.xlsx, the data are not formatted any more. Does Alteryx have a simple tool which can just change the file name?

Help

Accepted answers

FinnCharlton

Hi @zqlcancer , the easiest way to do this is with the Blob Input and Blob Output tools. They import and export files as Binary Large Objects, so no formatting is changed:

This approach will make a duplicate file with the new name, rather than renaming the original, though you can delete the original files with the Run Command tool later if you need to.

Rename Files.yxzp

All comments

mceleavey

Hi @zqlcancer ,

are you saying you just want to load it in and save it out as a new file?

FinnCharlton

Hi @zqlcancer , the easiest way to do this is with the Blob Input and Blob Output tools. They import and export files as Binary Large Objects, so no formatting is changed:

This approach will make a duplicate file with the new name, rather than renaming the original, though you can delete the original files with the Run Command tool later if you need to.

Rename Files.yxzp

zqlcancer

Basically I just wanted to changed the file name like how we change the file name in windows without creating addtional file. Not sure if Alteryx has a simple to tool for this.

lwolfie

There's a great macro in the gallery that does this as well, look for the File Directory Manager. https://community.alteryx.com/t5/Community-Gallery/File-Directory-Manager/ta-p/1026101

zqlcancer

Thanks, if Alteryx does not have a tool to change file name directly. Perhaps the best way for me is using Blob

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703