Syntax Error in Store Statement

Thu, 23 Feb 2017 15:17:02 GMT

Dear follow Qlikview users:

I'm having another problem. I'm loading excel files into Qlikview and keep getting errors with the store and drop tables statements. The files are loaded correctly into the app, but the store doesnt work.

Here's the load statement:

let vDataFolder = 'Excel_MMinutes\';
for each vFile in filelist('$(vDataFolder)*.xlsx')
if index(vFile, '~') = 0 then

MMinutes:

LOAD
[Unternehmen:],
[Nuvias Co:]
FROM
[$(vFile)]
(ooxml, embedded labels, table is Basics1, filters(
Transpose()));

Join

LOAD
[Customer #:],
[Report by:],
[Meeting Date:],
[Location:],
[Customer #:] & left([Report by:],5) & left([Meeting Date:],5) & [Customer #:] As MeetingMinutesID
FROM
[$(vFile)]
(ooxml, embedded labels, table is Basics2, filters(
Transpose()));

ENDIF

Next vFile

Here's the store statement:

FOR i =0 to NoOfTables()-1
LET vTabName = TableName(0);
STORE $(vTabName) into Raw_Data\$(vpath)$(vTabName).qvd (qvd);
DROP Table $(vTabName);
NEXT i

These are the two error messages:

Syntax error, missing/misplaced FROM:

STORE MMinutes-1 into Raw_Data\MMinutes-1.qvd (qvd)

Table not found

DROP TABLES statement

Does anybody have an idea what is going wrong?

Many thanks.

Dennis

topic Syntax Error in Store Statement in QlikView

Syntax Error in Store Statement