Saving a QVD with relative paths (Guardar un QVD con rutas relativas)

[olguita2014]

Hello,

I hope to help me, I want to save my application QVDs in relative paths to take on any machine

Translated with Google Translate - Qlik Community Administrative Team

Hola,

Espero me ayuden, deseo guardar los QVDs de mi aplicativo en rutas relativas, para poder ocupar en cualquier máquina

[settu_periasamy]

You can try the Directory;

Sample Script

DIRECTORY;
A:
Load * Inline [
Dim, Val
A,100
B,200
C,300
];
STORE A into A.qvd(qvd); //Save the QVD file into Current Directory qvw file.

//Store A into Buffer\A.qvd(qvd); //Uncomment this when you have the folder Buffer.Save the QVD file into Current path\Buffer Folder

[olguita2014]

I need store QVD for example:

Store A into $(ruta)\A.qvd

And I can change the rute into the variable

[settu_periasamy]

you need to set the variable . may be this helps.

DIRECTORY; // Directory reference - Qvw file location

//Relative path Folders

set vQVD=QVD;

set vBookmark=BookMark;

store File into $(vQVD)\Table.qvd (qvd);

[maxgro]

small example with absolute and relative path

set dir=c:\temp\new folder;

[a table]:

load RowNo() as FieldA AutoGenerate 100;

store [a table] into $(dir)\a table.qvd (qvd);

set dir=.\new folder;

[b table]:

load RowNo() as FieldB AutoGenerate 100;

store [a table] into $(dir)\b table.qvd (qvd);

[jonas_rezende · Accepted solution]

Hi, olguita2014 .

See the example with the image of the structure (attached) help.

Mark Relative Script

The folder structure goes like this:

• Extrator - Stores *.qvw;
• QVD - obviously stores QVD;
• QVDStage - stores raw data.

Therefore, within of the script the read going be like:

Set QVD = ..\QVD\;

Set QVDStage = ..\QVDStage\;

Set vTableStage = 'TableA';

Set vTable = 'TableETL';

$(vTable):

LOAD

A,

B,

C

FROM

[$(QVDStage)$(vTableStage).qvd]

(qvd);

Store [$(vTable)] INTO [$(QVD)$(vTable).qvd] (qvd);

Drop Table $(vTable);

I hope this helps