Rename File Dynamically and Copy to Different Path

Hi Guys especially to @DavidP

I found your sample workflow and would like to ask for the configuration of the copy template.bat. I do have a formatted template where I wanted to be rename and copy it to other folder. The format of the name changes everyday because I'm using formula "DateTimeToday()".

Hope to hear any answer. Thanks for the assistance.

Kamen

Workflow

Custom Tools

Date Time

Common Use Cases

Dynamic Processing

Run Command

Documentation

Accepted answers

All comments

binu_acs

@KamenRider have you tried using blob tools for copying your formatted input to another location, the below post will give you an idea of how blob tools works

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

KamenRider

HI @binu_acs ,

I am also working this blob thing however, I am unsuccessful since it does not copy the data to the excel template I made. Do you have an easy example?

binu_acs

@KamenRider Have you tried the given workflow in the post? would you be able to upload your template and input file?

KamenRider

Yes @binu_acs however, I am not successful. As far I remember, it was able to generate the template but the data didn't copy into the template.

Do you have any idea or samples to share?

Kamen

KamenRider

Hi @binu_acs

I tried your link - Blob and same results, I was able to copy the template in another location however empty. The data didn't copy. Do you know why? Kindly see below screenshot.

Hope to hear from you.

Thanks,

Kamen

binu_acs

@KamenRider Can you try the attached workflow, you can see the template and the output from the workflow in the below screen shot.

Blob_0907.yxzp

KamenRider

Hi @binu_acs

Tried to copy your workflow but same results, no data copied to my template. Can you know why? Please see my reference below.

Looking forward for your response.

Kamen

binu_acs

@KamenRider Did you run the workflow I gave you? Can you run that workflow and let me know if that is working for you or not?

KamenRider

Hi @binu_acs and others for help.

I am now able to successfully run the workflow with data on the template. I have follow-up question. Is it possible to add dynamic rename of the file by adding the datetoday() on the file?

Please advised.

Kamen

Felipe_Ribeir0

Hi @KamenRider

Maybe this topic could help you: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Batch-macro-to-filter-countries-and-output-to-excel/td-p/1056458

It is a different approach (using python), but it works.

If you want a direct link to the macro that is doing it: https://community.alteryx.com/t5/Community-Gallery/Copy-files-between-folders/ta-p/1056621

KamenRider

Hi @Felipe_Ribeir0

Thanks for the suggestion. My concerned now is how to rename the copied file with blob tool on it. Can you help me please?

Kamen

Felipe_Ribeir0

Hi @KamenRider

Test this workflow, it is not using the blob tool to rename.

https://community.alteryx.com/t5/Community-Gallery/Copy-files-between-folders/ta-p/1056621

You can just feed the macro with the current filepath and the new filepath (renamed) and it will work.

KamenRider

Hi @Felipe_Ribeir0

I tried your file renaming macro using python and I'm somewhat lost with the formula. Can you or someone to please assist me to correct it. Sample new name format is 2023-01-19_Thailand New Report.xlsx. The error shows below.

Also is it possible to connect the renaming workflow as shown below. The goal is to copy the file to designated folder and rename.

Please advise. Thanks.

Kamen

KamenRider

Hi @Felipe_Ribeir0

Below screenshot shows the error when I run the workflow for the 2nd time. This time the file is existing and would like to update it by overwriting. Please advise if there is something we can do to fix your macro.

Error for 2nd run of workflow.PNG

Hoping to hear from your the soonest.

Thank you for your continued assistance.

Kamen

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280