Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

View solution in original post

1 Reply
Highlighted
Not applicable

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

View solution in original post