Cut & past files from one location to another

[Ganesshh_95]

Hi All,

Greetings for the day!!!

I am not able to cut the excel files from one location & pasted it into another location. 

It would be really  helpful if you could help me to resolve this issue. Please help me.

Thanks in Advance

[Qiu]

Move files are not specialty of Alteryx.
Alteryx is for Data, not Files. 😁

[SPetrie]

You would need to use a run command tool and create a batch file that does the move operation for you. This post has a similar concept but with renaming files, you would want to make it your own by changing it to be move commands instead.

[Deano478]

@Ganesshh_95 as @Qiu said Alteryx is not a tool that is known for this kind of operation if your using windows you can create a PowerShell script to complete the operation quite easily.

[Hub119 · Accepted solution]

As mentioned above, you can use the "move" command within the Run Command tool to execute the command line prompt.  You will want to pull in the full file path of your original file you are seeking to move, and then also the Destination Directory (directory only here... you already have the file name contained in the first part when you point to the source file).  Using a formula tool create a formula for a field called "cmd" that looks something like the following using those 2 fields I already mentioned (using a field as reference you can pull in several files with a directory tool and move them all at once):

'move "' + [FullPath] + '" "' + [DestinationDirectory] +'"'

Place a select tool after your formula tool to deselect all fields except the "cmd" field you just created.  Then connect the Run Command tool and configure like so:

[Hub119]

FYI... if you ever want to COPY a file from one location to another, the process is almost identical... just replace "MOVE" with "COPY" in the CMD text that you generate in the formula tool.