Discussion Board for collaboration on QlikView Scripting.
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?
Go to 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
'$(sheetName)' as [Item Class Trial]
(ooxml, embedded labels, table is [$(sheetName)]);
store [Items-$(sheetName)] into C:\Qlikview\QVD\PSD QVD\Items QVD\Items-$(sheetName).qvd;
DROP Table [Items-$(sheetName)] ;