Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to get the path of a document from the mounted folder in the reload script? For example if the mounted folder is "MountedFolder" and the qlikview document "Test.qvw" is in a subfolder "SubFolder" of the mounted folder, I would like to have the following return: "MountedFolder/SubFolder/Test.qvw".
Is there a way to achieve that?
use =DocumentPath() function.
I have tried that but it returns the absolute path of the qlikview document.
It is very interesting but it is not really a solution to my problem.
Hello try this expression:
mid(DocumentPath(),index(DocumentPath(),'\',-3)+1)
This should return the document path in you desired format.
Thank you for the answer. It works for the example that I gave but It was just an example. In reality, I don't know how many subfolders I have from the mounted folder in QMC to the qlikview document. I have seen that the path I am looking for is exactly the same as the task name of the reload task scheduled in QMC for the qlikview document. So maybe I should rephrase the question:
Is there a way to get the task name of the reload task scheduled in QMC for a qlikview document?
Not sure how to retrieve the task name. Are all mounted folders in a common location? If yes, then the expression can be modified to give your desired result.
When you get the path to the mounted folder what are you hoping to do with it ?
look at governance dashboard script,hopes u will find.