File upload

[Anonymous]

I have linked an excel file to my qlikview application but I have moved the file several times and when I reload the app it can never find the excel file, rightfully so.

Is there a way that I can prevent this and anytime I move the folder the app can still locate the file?

I remember in a training class discussing vPathName in the SET but not sure if that would be correct. If so, could someone provide an example, thanks.

[Anonymous · Accepted solution]

You can create a variable that contains path to the file, e.g. vPath, with definition:
D:\MyProject\DataFolder\

And, in the script:
LOAD  ... FROM $(vPath)MyFile.xlsx....

Every time you move the file, modify the variable definition manually.

[Anonymous]

Sorry, what does the $ sign represent?

[Anonymous]

This is how you refer to a variable in the script.  Variable name is vPath in this case, so you refer to it as $(vPath) - notice it was a typo in my response, missed 'v', fixing.  During the execution if you look into the log file, the variables are replaced with their values, in this example it will be

LOAD  ... FROM D:\MyProject\DataFolder\MyFile.xlsx....