How to solve this error 'File extdata.cpp, Line 2754'

Wed, 01 Aug 2012 01:41:14 GMT

Hi,

I've use loop to get data in a multiple sheets of one workbook. But then, I got this error (see figure below)

How can I prevent that error? Can anyone help me get through this?

Thanks,

-Bill

Re: How to solve this error 'File extdata.cpp, Line 2754'

Wed, 01 Aug 2012 07:09:21 GMT

This is already answered by me. Highlighted red are lines inserted.

FOR i = 0 to NoOfRows('tables')-1

LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));

if Right('$(sheetName)',8) <> 'Database' then

[Items-$(sheetName)]:

LOAD *,

'$(sheetName)' as [Item Class Trial]

FROM

(ooxml, embedded labels, table is [$(sheetName)]);

store [Items-$(sheetName)] into C:\Qlikview\QVD\PSD QVD\Items QVD\Items-$(sheetName).qvd;

DROP Table [Items-$(sheetName)] ;

end if;

NEXT i