Copy an Excel file from one location to another (Dynamic Locations)

[sakshim]

Hi folks,

I need to copy excel file which gets created on monthly basis and paste it to different location. Here, file gets created in different folder every month. i.e June file will be created in June folder, July File in July folder. So I can reach to the location by dynamically coding the workflow but not been able to copy exact file to the different location using Run_command tool as it is always changing the content of the file. Also, I'm not comfortable with this tool as not able to understand the process/ examples already provided on the community. Can a request for help please.

Regards,

Sam

[binuacs]

@sakshim 

Copy Files from One Folder to Another - Workflow o... - Alteryx Community

[BrandonB]

I like the blob tool approach as discussed here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Copy-and-Paste-Excel-from-one-folder-t... 

[sakshim]

Can I add the date time stamp to the file at output location ? I tried  but it has created some txt file and renamed it.

[Sunceray]

I was able to include a dynamic date in the filename by adding a ReportDate field with the current (DateTimeToday()).