topic Re: EXECUTE command to MOVE shared files but DON'T Overwrite in QlikView

EXECUTE command to MOVE shared files but DON'T Overwrite

dmohanty — Wed, 18 Nov 2015 21:22:30 GMT

Hi All,

I am able to use the EXECUTE command to MOVE my shared files from one folder to another. But as it is a daily reload, I need the new Shared Files that are to be moved the next day, have to be just pasted separately and NOT Overwrite the existing ones in the destination folder.

Below is the script I am using:

execute cmd.exe /C MOVE "C:\QVWs\*.shared" "C:\QVWs\Shared Files Folder";

Can someone please help here?

Re: EXECUTE command to MOVE shared files but DON'T Overwrite

swuehl — Wed, 18 Nov 2015 21:49:47 GMT

Maybe just use separate subfolders per day?

Let vToday = Date(Today(),'YYYY-MM-DD');

execute cmd.exe /C MKDIR "C:\QVWs\Shared Files Folder\$(vToday)";

execute cmd.exe /C MOVE "C:\QVWs\*.shared" "C:\QVWs\Shared Files Folder\$(vToday)";

Re: EXECUTE command to MOVE shared files but DON'T Overwrite

petter — Wed, 18 Nov 2015 22:42:57 GMT

An extra tip about moving files is that ROBOCOPY.EXE (Robust File Copy for Windows) is a very good alternative to MOVE which is also a standard program coming with Windows. It has tons of more special options....

Felt that it could be worth mentioning it. Swuehl's anwser should do the trick for you.

Re: EXECUTE command to MOVE shared files but DON'T Overwrite

dmohanty — Mon, 23 Nov 2015 19:06:02 GMT

Hi swuehl‌,

Thank you very much for this.

This has helped and worked!

Re: EXECUTE command to MOVE shared files but DON'T Overwrite

dmohanty — Mon, 23 Nov 2015 19:06:35 GMT

Thanks petter.skjolden‌,

Thank you for this additional info!