Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1 Solution
Accepted Solutions
Hello,
In your use case scenario you will have to use the EXECUTE [1] command.
Here are the steps that you should follow:
- Create a folder that you want to monitor for a file creation. e.g. "My Location" folder on "Desktop"
- Open Notepad and copy paste: >> "echo Qlik Sense reload was completed! > "C:\...\Desktop\My Location\log.txt" <<
- Note: The quotes are included in the statement, because if your path has spaces it will fail. But using quotes will work every time, either the path has spaces or not.
- Click on Save As
- Choose Name "executable.bat"
- Choose Save as type "All files (*)"
- Note: You have to make sure that your saved file is NOT named executable.bat.txt but is named executable.bat. Otherwise, it will not get executed by CMD.
- In Qlik Sense you have to setup some configurations first, so follow the steps in the official documentation [1] carefully.
- Now open Data load editor and add the following statement at the end of the script:
- Execute "C:\Windows\System32\cmd.exe" /R "C:\Users\...\Desktop\My Location\executable.bat"
- This will use the CMD in the defined path (first part of the command) and will execute the "executable.bat" that you have created.
- When the bat file is executed, you will see that the "log.txt" will be created.
- You can modify the text that you are saving in the bat file to make it unique each time e.g. saving the current date and time that the log.txt was created. This way when you read the file with another software you will know if the file was created recently etc.
Here is my result after Data load editor finished execution:
I hope that this information was helpful.
---
Hello,
In your use case scenario you will have to use the EXECUTE [1] command.
Here are the steps that you should follow:
- Create a folder that you want to monitor for a file creation. e.g. "My Location" folder on "Desktop"
- Open Notepad and copy paste: >> "echo Qlik Sense reload was completed! > "C:\...\Desktop\My Location\log.txt" <<
- Note: The quotes are included in the statement, because if your path has spaces it will fail. But using quotes will work every time, either the path has spaces or not.
- Click on Save As
- Choose Name "executable.bat"
- Choose Save as type "All files (*)"
- Note: You have to make sure that your saved file is NOT named executable.bat.txt but is named executable.bat. Otherwise, it will not get executed by CMD.
- In Qlik Sense you have to setup some configurations first, so follow the steps in the official documentation [1] carefully.
- Now open Data load editor and add the following statement at the end of the script:
- Execute "C:\Windows\System32\cmd.exe" /R "C:\Users\...\Desktop\My Location\executable.bat"
- This will use the CMD in the defined path (first part of the command) and will execute the "executable.bat" that you have created.
- When the bat file is executed, you will see that the "log.txt" will be created.
- You can modify the text that you are saving in the bat file to make it unique each time e.g. saving the current date and time that the log.txt was created. This way when you read the file with another software you will know if the file was created recently etc.
Here is my result after Data load editor finished execution:
I hope that this information was helpful.
---
