Macro to move file?

Hamder83

Hi

Anyone knows of a simple macro to move files? 

Ive tried googeling for a while now, but havnt faound anything I can make work.

I want to be able to use a directory input to get all files.
They contains which week they are created and a customer number.

From that info I want to move the files to the correct sub folder based on Customer number and week.

So: 
FileName: Dennis_Schlein (Customer) 270183 (ID) - Week 8.

Destination:
P:\Invoice\[Customer name]\Week 8\ 

Anyone who can assist with something like this? 


Kind regards

afv2688

Hello @Hamder83 ,

To move files you would need yo use the command tool. The best way to do it would be to create a batch macro with the following command

move "<origin>" "<destination>"

The quotes are important and useful just in case any path has some spaces (we would avoid that error this way).

Here is a macro that does it:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Configure-Run-Command-tool-to-move-a-file/td-p/11139

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards