topic Re: File upload in QlikView https://community.qlik.com/t5/QlikView/File-upload/m-p/848159#M1017987 <HTML><HEAD></HEAD><BODY><P>This is how you refer to a variable in the script.&nbsp; Variable name is vPath in this case, so you refer to it as $(vPath) - notice it was a typo in my response, missed '<STRONG>v</STRONG>', fixing.&nbsp; During the execution if you look into the log file, the variables are replaced with their values, in this example it will be</P><P></P><P>LOAD&nbsp; ... FROM <STRONG>D:\MyProject\DataFolder\</STRONG>MyFile.xlsx....</P></BODY></HTML> Thu, 02 Apr 2015 19:30:54 GMT Anonymous 2015-04-02T19:30:54Z File upload https://community.qlik.com/t5/QlikView/File-upload/m-p/848156#M1017984 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Is there a way that I can prevent this and anytime I move the folder the app can still locate the file?</P><P></P><P>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.</P></BODY></HTML> Thu, 02 Apr 2015 19:06:33 GMT https://community.qlik.com/t5/QlikView/File-upload/m-p/848156#M1017984 Anonymous 2015-04-02T19:06:33Z Re: File upload https://community.qlik.com/t5/QlikView/File-upload/m-p/848157#M1017985 <HTML><HEAD></HEAD><BODY><P>You can create a variable that contains path to the file, e.g. <STRONG>vPath</STRONG>, with definition:<BR />D:\MyProject\DataFolder\</P><P></P><P>And, in the script:<BR />LOAD&nbsp; ... FROM $(<STRONG>vPath</STRONG>)MyFile.xlsx....</P><P></P><P>Every time you move the file, modify the variable definition manually.</P></BODY></HTML> Thu, 02 Apr 2015 19:15:05 GMT https://community.qlik.com/t5/QlikView/File-upload/m-p/848157#M1017985 Anonymous 2015-04-02T19:15:05Z Re: File upload https://community.qlik.com/t5/QlikView/File-upload/m-p/848158#M1017986 <HTML><HEAD></HEAD><BODY><P>Sorry, what does the $ sign represent? </P></BODY></HTML> Thu, 02 Apr 2015 19:23:12 GMT https://community.qlik.com/t5/QlikView/File-upload/m-p/848158#M1017986 Anonymous 2015-04-02T19:23:12Z Re: File upload https://community.qlik.com/t5/QlikView/File-upload/m-p/848159#M1017987 <HTML><HEAD></HEAD><BODY><P>This is how you refer to a variable in the script.&nbsp; Variable name is vPath in this case, so you refer to it as $(vPath) - notice it was a typo in my response, missed '<STRONG>v</STRONG>', fixing.&nbsp; During the execution if you look into the log file, the variables are replaced with their values, in this example it will be</P><P></P><P>LOAD&nbsp; ... FROM <STRONG>D:\MyProject\DataFolder\</STRONG>MyFile.xlsx....</P></BODY></HTML> Thu, 02 Apr 2015 19:30:54 GMT https://community.qlik.com/t5/QlikView/File-upload/m-p/848159#M1017987 Anonymous 2015-04-02T19:30:54Z