topic Re: Store a file with a relative path in QlikView

Store a file with a relative path

Thu, 21 Aug 2014 09:59:58 GMT

Hello everyone,

When I extract data from file with a relative path, I use this syntax :

FROM

[..\Extract\blabla\subscriptions_offer.qvd]

(qvd);

I would like to do something like that when I store a qvd.

Currently I am using a variable :

Let QVD_Path ='D:\Qlikview_Data\QVD\';

and then in the code : STORE OneTable into $(QVD_Path)QVD_all\OneTable.qvd;

So, I would like to use as well "../.." because when I move my application somewhere else the variable QVD_Path doesn't have the same value. And I don't want to change it each time I move my application.

I've tried STORE into ..\..\QVD\QVD_all\OneTable.qvd

But it doesn't work...

In the same folder, I have a folder "Extract" that contains my application and I have a folder "QVD" which contains the stored tables.

Thank you for your help

Re: Store a file with a relative path

jagan — Thu, 21 Aug 2014 10:08:14 GMT

Hi,

Try like this

STORE into ..\QVD\QVD_all\OneTable.qvd

Regards,

Jagan.

Re: Store a file with a relative path

Thu, 21 Aug 2014 10:08:28 GMT

Got your Question, Its a simple one. However your folder structure is not very clear.

Can you tell me

1. Where is your QVW application residing(Absolute Path)

2. Where do you want to place the QVD(Absolute Path)

3. Where you are picking up the QVD's(Absolute Path)

Ram

Re: Store a file with a relative path

Gysbert_Wassenaar — Thu, 21 Aug 2014 10:09:14 GMT

You can use the DIRECTORY keyword to set a path first. You can then use relative paths based on the path you set with the DIRECTORY keyword.

DIRECTORY D:\Qlikview_Data\QVD\;

STORE OneTable into ..\..\QVD\QVD_all\OneTable.qvd

OneTable.qvd will then be created in D:\QVD\QVD_all\OneTable.qvd

Adjust the paths as necessary to match your folder structure.

Re: Store a file with a relative path

Thu, 21 Aug 2014 10:49:35 GMT

My application is in : D:\Qlikview_Data\Référentiel\ref.qvw

I want to store my new qvd into : D:\Qlikview_Data\QVD

To create my new qvd, I am using QVD that are in :D:\Qlikview_Data\Extraction

So i cannot really use "directory" because the qvd i use and the qvd i create are not supposed to be at the same place.

Thanks for your help

Re: Store a file with a relative path

Thu, 21 Aug 2014 10:54:54 GMT

Hi Ram,

My application is in : D:\Qlikview_Data\Référentiel\ref.qvw

I want to store my new qvd into : D:\Qlikview_Data\QVD

To create my new qvd, I am using QVD that are in :D:\Qlikview_Data\Extraction

thanks for your help

Re: Store a file with a relative path

Gysbert_Wassenaar — Thu, 21 Aug 2014 11:00:11 GMT

You can use the DIRECTORY keyword as many times as you need.

DIRECTORY C:\MyFoo;

TableA:

LOAD * FROM Cats.qvd (qvd);

DIRECTORY D:\some\where\else\completely;

STORE TableA into ..\..\in\the\woods;

Re: Store a file with a relative path

Thu, 21 Aug 2014 11:04:39 GMT

Can you try this.

Store xyz into ..\..\Extraction\xyz.qvd(qvd);

-Ram

Re: Store a file with a relative path

Thu, 21 Aug 2014 11:05:20 GMT

Can you try this.

Store xyz into ..\..\Extraction\xyz.qvd(qvd);

-Ram

Re: Store a file with a relative path

Thu, 21 Aug 2014 11:40:18 GMT

I managed to do it.

Thank you all