Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax Error in Store Statement

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:

1)

Syntax error, missing/misplaced FROM:

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

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

2)

Table not found

DROP TABLES statement

Does anybody have an idea what is going wrong?

Many thanks.

Dennis

0 Replies