Script path error

[fkeuroglian]

Hi, expert

i export one script from qlikview to sense, when i try to reload, i have some problems with the variables or path i have created before

for example:

SET Path_QVD='..\2_QVD\';

SET Path_Recursos='../1_Resources/';

// ****** Tabla HNUA12 ******

Saldos:

LOAD

     *,

year(%Fecha) as KeyAño,

'Saldo Real' as TipoSaldo,

HnuA12TIT as ID_Titulo

FROM

$(Path_QVD)HNUA12.qvd(qvd);

exit Script;

in qlikview work perfect, and the root folder and the qvd exist ok, what could be?

i have this error, the same happend if i use the sentences $(Include=..\1_Resources\Creacion_Variables.txt);

Attached the error

thank you!

Fernando

[jagan · Accepted solution]

Hi,

You need to folder connection by using Create New Connection -> Folder and then use it in the file path by using  like below

LOAD

    *

FROM 'lib://Test/TestFile.xlsx'

(ooxml, embedded labels, table is [Report]);

Refer attached screenshot .

Regards,

jagan.