Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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