Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

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

                   

                     (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

1 Reply
Not applicable

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

                   

                     (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