Folder Paths using Variables

[#1]

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?

[jagan]

Hi,

Try like this

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

Regards,

Jagan.

[#3]

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.

[jagan]

Hi,

Check whether you have access to this path?

OR

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

\\BATJHBQLDZWN001\QlikView\QVDeploy\VIPRestrictedModels\

Regards,

jagan.

[nagarjuna_kotha · Accepted solution]

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

[#6]

Thanks! this worked

[nagarjuna_kotha]