Copy files from 1 directory to another directory based on certain conditions

Question

I have files in one directory and based on target date, I want to replace those files present in another directory. Basically I want to update the latest file from 1st directory folder to another. I have designed all the logic, I am just not able to write the output in the second directory.

alteryx query.PNG

Sebastian_Chaieb2 · Answer

Hi @NISHA_373

Dose the solution works for you? If yes, please tag my response as Solved.

Thanks,

Sebastian

Sebastian_Chaieb2 · Answer

Please try attached solution.

I used same file in both location (so in the Join tool it is joined based on FullPath from both folders. So if the file name is the same it will be copy (in my example moved from folder 1 to folder 2. In the Run Command tool you can check how it is configured (in simple words, I am creating a cmd in Formula, it is outputted to temporary file %temp%\rmdir.bat (I should change the name but already attached :P) and in Command it is calling that temp file saved as BAT.

In cmd (in formula I used "MOVE" instead of "Copy" to check if command is working) so you can change it again to COPY.

If that solution works, please tag this response as SOLVED :)

Thanks,

Sebastian

Solution_with_RUN_SC.yxmd

NISHA_373 · Answer

I am trying to use the Run Command tool but it's giving me error even though I have given the right path in my command.

alteryx error.PNG

alteryx error 2.PNG