topic Re: Cannot open file in QlikView

Cannot open file

ashokpaladugula — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Cannot open file

marcus_sommer — Wed, 04 Jan 2017 12:28:14 GMT

Try it with:

...

FROM

[$(vSourceData)Student.xlsx]

...

- Marcus

Re: Cannot open file

awhitfield — Wed, 04 Jan 2017 12:41:11 GMT

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

Andy

Re: Cannot open file

vinieme12 — Wed, 04 Jan 2017 12:43:51 GMT

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

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

Re: Cannot open file

awhitfield — Wed, 04 Jan 2017 12:46:37 GMT

Hi Ashok,

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

Andy

Re: Cannot open file

muthukumar77 — Thu, 05 Jan 2017 07:28:45 GMT

Hi,

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

Can you send me your project folder structure?

Re: Cannot open file

vinieme12 — Thu, 05 Jan 2017 08:41:30 GMT

ashokpaladugula

please close the thread if your issue is resolved.