topic Load from Windows' environment variables path? in QlikView

Load from Windows' environment variables path?

Mon, 14 May 2012 18:15:55 GMT

Did some Googling but couldn't find this answer .. does anyone know if data sources can be referenced using Windows environment variables to define the path? Eg %HOMEPATH% = \Documents and Settings\{username}

Load from Windows' environment variables path?

rbecher — Mon, 14 May 2012 19:05:23 GMT

Hi,

I think it is not possible to use environment variables directly in the LOAD statement. But you can read a path from the registry:

let vPath=GetRegistryString('HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders','Personal');

LOAD *

FROM $(vPath)\test.qvd (qvd);

- Ralf

Load from Windows' environment variables path?

Mon, 14 May 2012 20:37:24 GMT

Thanks Ralf that is as good as!