topic Re: Folder Paths using Variables in QlikView

Folder Paths using Variables

Fri, 10 Apr 2015 05:49:33 GMT

Hi All

We have just upgraded to the new QV 11 and server.

I am having an issue with one model that is failing on the new server due to new folder structure and server name.

Path on Old Sever: \\ba-batqlv001\d$\QlikViewDataModels\VIPRestrictedModels\VIPQVD\

The same folder path on our new server is as follows:

Server Name: BATJHBQLDZWN001

Folder path: D:\QlikView\QVDeploy\VIPRestrictedModels

How can I change the variable with the new path successfully?

Re: Folder Paths using Variables

jagan — Fri, 10 Apr 2015 05:56:31 GMT

Hi,

Try like this

\\BATJHBQLDZWN001\d$\QlikView\QVDeploy\VIPRestrictedModels\

Regards,

Jagan.

Re: Folder Paths using Variables

Fri, 10 Apr 2015 06:10:55 GMT

Hi Jagan

I have tried that and it fails.

Cannot open file '\\BATJHBQLDZWN001\d$\QlikView\QVDeploy\VIPRestrictedModels\VIPQVD\

VIP_LEAVE.QVD' The filename, directory name, or volume label syntax is incorrect.

Re: Folder Paths using Variables

jagan — Fri, 10 Apr 2015 06:15:30 GMT

Hi,

Check whether you have access to this path?

share the Qlikview drive in that machine and use the below path

\\BATJHBQLDZWN001\QlikView\QVDeploy\VIPRestrictedModels\

Regards,

jagan.

Re: Folder Paths using Variables

nagarjuna_kotha — Fri, 10 Apr 2015 06:17:05 GMT

Hi ,

try this >>>>

Ex :

LET vPath='C:\Users\Nagarjuna\Downloads';

LOAD PK_TRANSACTION,

[Trans Start DateTime],

[Trans End DateTime]

FROM

[$(vPath)\Transactions.xlsx]

(ooxml, embedded labels, table is trans);

Let me know If it works or not....

Regards,

Nagarjuna

Re: Folder Paths using Variables

Fri, 10 Apr 2015 08:07:00 GMT

Thanks! this worked

Re: Folder Paths using Variables

nagarjuna_kotha — Fri, 10 Apr 2015 10:57:24 GMT