topic Re: QVD changed path in QlikView

QVD changed path

felcar2013 — Wed, 02 Jan 2013 15:19:46 GMT

i am new to QV. In my script i access to qvd files located in a file server. I reorganized the qvd files and relocated them in a different folder. Now when i reload the script it was clear that the application does not recognize the path of the qvds. What should i do so that QV recognizes the new location of the qvds? Is it possible to create a text file with the path of the qvd files location and then use an "include" statement to call it?

thanks

felipe

Re: QVD changed path

alexpanjhc — Wed, 02 Jan 2013 15:45:04 GMT

I created a folder c:\QVW\ include and in that folder i have a file called Data_file_locations.txt

i have only one line in that file

SET vDFLocation = 'c:\QVW\Data\';

then in your script, you would need something like

// Get the directory that the QVW is being reloaded from.

LET v_RootDirectory = Replace (DocumentPath (), '\' & DocumentName (), '');

// Bring in variables from the Include directory file.

$(Include=$(v_RootDirectory)\Include\Data_File_Locations.txt);

// Setup locations of different data sources.

SET v_QVDFolder = '$(vDFLocation)QVD\';

SET v_ExcelFolder = '$(vDFLocation)Excel\';

SET v_CSVFolder = '$(vDFLocation)CSV\';

SET v_ExcelControlFolder = '$(vDFLocation)Excel\';

when you load your source file(qvd or excel )

you'd need to do

LOAD

*
FROM
[$(v_ExcelControlFolder)INTAKE.xlsx]
(ooxml, embedded labels, header is 2 lines, table is INTAKE);

LOAD

*
FROM
[$(v_QVDFolder ))INTAKE.qvd];

when you change to the new system/location, you just need to change the include file.

HTP.

Re: QVD changed path

Wed, 02 Jan 2013 15:46:41 GMT

example:

set QVDPath='./QVD/';

Store * from MYTABLE into $(QVDPath)MYTABLE .QVD;

Re: QVD changed path

felcar2013 — Wed, 02 Jan 2013 16:39:56 GMT

thanks, i am trying this out

Re: QVD changed path

felcar2013 — Thu, 03 Jan 2013 10:01:52 GMT

thanks it worked !

Re: QVD changed path

felcar2013 — Fri, 04 Jan 2013 09:27:57 GMT

thanks Cristina

it was also very useful