I upgraded Qlik Sense Desktop to September 2017 yesterday and it seems to have stopped "EXECUTE cmd.exe" functions from working in my load scripts. I use this to move csv files to an Archive folder once I have loaded them to a QVD. As an example, the script I am using is:
LET File = 'T:\QS Exports\Test.xlsx';
execute cmd.exe /c move "$(File)" "T:\QS Exports\Archive\";
And these are the settings I have in the settings.ini file:
When running in Debug mode, the Output just has this:
execute cmd.exe /c move "T:\QS Exports\Test.xlsx" "T:\QS Exports\Archive\"
And I used to see a cmd window appear briefly whenever the command was executed, but now I don't see anything. Has anyone had the same issue?
Hi Check below link.
It says it wont work in standard mode.
I believe the StandardReload=0 setting which I showed above means that the program is running in Legacy mode, so the statement should still work?
Apologies I never posted the result on here straight away. Looked back through my script and found I got it working by adapting it to the below:
execute cmd.exe /C move /Y "$(File)" "$(FileDestination)";
Hope that helps.