Batch Files - Copying Files

[kheuer]

Hello,

I have a run command process that used to run for me which would copy a file from one network file directory to another. This solution recently start failing and I tried to implement the solution listed in the link below, but I can't quite figure it out. I attached my workflow with both the previous solution as well as the new one. If anyone can help me figure out how I can get either one to work, I would super appreciate it.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Batch-Files-in-Alteryx-Part-2-Movin...

[smoskowitz]

Here is what I have done.

@Echo OFF

echo F|xcopy "Filename.xlsx" "Filename_%date:~10,4%_%date:~4,2%_%date:~7,2%_%time:~0,2%%time:~3,2%.xlsx" /Y

Basically, it copying a file from one location to another and adding a date/time stamp.

Save the file as a batch and run it before or after a workflow.

Here is an article that might help with creating batches.

Hope it helps!

Seth

[smoskowitz]

Also, here is my version of that article.

[kheuer]

@smoskowitz - thank you. Unfortunately you are running a different version of Alteryx and I cannot open your package. 😞   

Regarding your response, are you saying I should adjust my formula? I am still a novice.

[smoskowitz]

What version of Alteryx are you running?

[kheuer]

[smoskowitz · Accepted solution]

Odd, it's done in 2018.4. Attached is just the workflow. Create a folder called c:\test2 and drop some Excel files in there. let me know if that works.

Seth

[kheuer]

Awesome!!! That worked. Thank you soooooo much.

[Mgaurav2grt]

awesome, thanks so much