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