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

[#1]

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

[#2 · Accepted solution]

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