Cannot open file

[ashokpaladugula]

Hi All,

I'm getting error while open loading the from file. My code like below.

Please help me;

SET vSourceData ="E:\BI\QlikViewSamples\NewOSWork\Incremental Model\DataFiles\";

SET vSaveQvd = "E:\BI\QlikViewSamples\NewOSWork\Incremental Model\QVDs\";

LET vQVDCreatedDate = QvdCreateTime("$(vSaveQvd)StudentsList.qvd");

Student:

LOAD Id,

     Name,

     Address,

     M1,

     M2,

     M3,

     M4,

     Total,

     Division,

     Updated

FROM

$(vSourceData)Student.xlsx

//

(ooxml, embedded labels, table is Students);

Store Student into $(vSaveQvd) StudentsList.qvd(qvd);

[marcus_sommer]

Try it with:

...

FROM

[$(vSourceData)Student.xlsx]

...

- Marcus

[awhitfield]

can you post a screen shot of the actual error that you get?

Andy

[vinieme12]

Wrong Quotes in Variable Definition, in Qlikview we use Single Quotes for String

So

SET vSourceData = 'E:\BI\QlikViewSamples\NewOSWork\Incremental Model\DataFiles\';

SET vSaveQvd = 'E:\BI\QlikViewSamples\NewOSWork\Incremental Model\QVDs\';

LET vQVDCreatedDate = QvdCreateTime('$(vSaveQvd)StudentsList.qvd');

Student:

LOAD Id,

     Name,

     Address,

     M1,

     M2,

     M3,

     M4,

     Total,

     Division,

     Updated

FROM

[$(vSourceData)Student.xlsx]

//

(ooxml, embedded labels, table is Students);

Store Student into $(vSaveQvd)StudentsList.qvd(qvd);

[awhitfield]

Hi Ashok,

can you copy and paste the actual text from the load script, looks like you have retyped it....

Andy

[muthukumar77]

Hi,

Can you send me screen shot of error message while loading the file?

Can you send me your project folder structure?

[vinieme12]

ashokpaladugula

please close the thread if your issue is resolved.