Rename and convert files in a folder with Creation date of the original file

[Atson]

All,

Looking for support to Rename the existing XLSX files by selecting the folder and sub folders within by adding the original creation date to the existing file name and then converting to csv.

Eg: 

Original File name: EMEA SOD-7324491540623144819.xlsx

Rename and converted name: EMEA SOD-24102023.csv

Appreciate any support on this

[caltang]

I asked this question a while back: 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamically-Rename-Output-File...

In that post contains some solutions that you will find useful. :) 

[Atson]

HI @caltang, i checked the link but this does not provide much on the renaming with the Actual Creation date of the original file.

[caltang]

You’ll need to implement it yourself using the logic you desire. In your case, you need to get the dates from the file correct? 

You can use a Directory tool to get the information you desire, from there, connect it to CMD as per linked to rename your files to the appropriate date. 

If you need some help, I suggest for you to provide some sample data.