Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokpaladugula
Contributor III
Contributor III

Cannot open file

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);

6 Replies
marcus_sommer

Try it with:

...

FROM

[$(vSourceData)Student.xlsx]

...

- Marcus

awhitfield
Partner - Champion
Partner - Champion

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

Andy

vinieme12
Champion III
Champion III

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);

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
awhitfield
Partner - Champion
Partner - Champion

Hi Ashok,

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

Andy

muthukumar77
Partner - Creator III
Partner - Creator III

Hi,

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

Can you send me your project folder structure?

Muthukumar Pandiyan
vinieme12
Champion III
Champion III

ashokpaladugula

please close the thread if your issue is resolved.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.