Previously I have built several QlikView applications which make use of Windows command functions (e.g. "EXECUTE cmd.exe /c del $(File)"). In order to let this work smoothly, I enabled the setting "Can Execute External Programs" in the Script Editor sub-menu.
I would to transfer the script to a Qlik Sense application. Transferring the script is not a big deal but where can I find this option in Qlik Sense?
I understand for Qlik Sense you will need to modify the Settings.ini file located in the folder
However, I see this is not working as I still get the following error:
EXECUTE statement not available in this script mode.
Someone any idea whats going on? Please note the entire script is working fine in QV.
That's correct. Idea was the Qlik application to execute the Windows Commands, however I still haven't found a way to do this in Sense. As a workaround I created a .BAT script and scheduled this using Task Scheduler in order to remove the files on a regular basis.
Commands in the script could look like :
XCOPY /Y \\['File server']\Qlik\['Source System']\*.txt "D:\0. Data\1. ['Source system files']"