Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to send a report using tabular reporting to a SharePoint location and then overwrite the exisiting file that was there. I have been running into issues due to the "Output" having a unique timestamp format. Is there any way to make this possible?
Thanks!
I think we could use QAA to delete the existing file(s) in the sharepoint location using the QAA Sharepoint connector and the 'delete file' block. The same QAA could trigger the reload of a Qlik app (which can automatically trigger the report-task execution). Would that work?
There is no native feature to overwrite the report in sharepoint using the report task features alone unfortunately.
Just FYI I did some testing and the QAA approach would work
1. Configure a report task to execute when the app is reloaded.
2. Use QAA to list reports that are found in a sharepoint folder (the same destination folder for the report task)
3. In the automation, delete any files with the same naming convention as the report defined in the report task
3. As a final step in the automation, trigger a reload of the Qlik Sense App
I tried something similar to this, but ended up utlizing "Label" and "Go to Label" Blocks due to when the tabular report gets sent to SharePoint, it will not give it enough time to rename the file after you delete the orginal one.