1 Reply Latest reply: Aug 1, 2012 3:13 AM by Bill Ringer Salalima RSS

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

      Hi,

       

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

       

      error.png

       

      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'

          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

                              [C:\Qlikview\DataSource\PSD DS\Item.xlsx]

                               (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