topic Re: Can I use the variable %USERPROFILE% in my load script? in QlikView

Can I use the variable %USERPROFILE% in my load script?

patbuchanan — Mon, 07 Jul 2014 20:11:59 GMT

I'm trying to edit a script to use %USERPROFILE% instead of using c:\users\computer name\ to help someone who moves around to different machines that has Qlikview licenses and has the their excel file loaded in the same dropbox location on each computer. So, instead having to change the load statement and create different files, I was trying to use the path to the %USERPROFILE%...

//[%USERPROFILE%\Dropbox\Apps\Attachments\Data.xls

Re: Can I use the variable %USERPROFILE% in my load script?

gmoraleswit — Mon, 07 Jul 2014 21:09:49 GMT

You can do something like this:

EXECUTE cmd.exe /c echo %USERPROFILE% > user.txt;

path:

LOAD @1 as userpath

FROM

user.txt

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

let v = Peek('userpath',0,'path');

DROP Table path;

Check attachment.

Hope this helps.

Re: Can I use the variable %USERPROFILE% in my load script?

rwunderlich — Tue, 08 Jul 2014 00:24:47 GMT

You can't access the variable directly, but you can use the GetFolder() function to retrieve the same value.

LET vUserprofile = GetFolderPath('Profile');

LOAD ...

FROM [$(vUserprofile)\Dropbox\Apps\Attachments\Data.xls

-Rob

http://masterssummit.com

http://robwunderlich.com