FOR each... loop in script

[maxsugak]

Hi,

I'm trying to load multiple Excel sheets from 1 file, using the FOR loop.

But got a mistake when implemeting it:

FOR Each sheet in 'Sheet 1', 'Sheet 2' 

[Test]:
LOAD F1 as ValueType, 
     F2 as Brand
FROM
[Excel.xls]
(biff, embedded labels, header is 4 lines, table sheet)
NEXT

I think the problem is in sheet naming there - 

(biff, embedded labels, header is 4 lines, table sheet)

Any suggestions please? 

[pradosh_thakur]

Try

(biff, embedded labels, header is 4 lines, table is [$(sheet)])


Have a look.

https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-wit...

[maxsugak]

Thanks,

I've tried but got error Cannot locate table in BIFF file

[pradosh_thakur · Accepted solution]

(biff, embedded labels, header is 4 lines, table is [$(sheet) & '$'])
or

(biff, embedded labels, header is 4 lines, table is [$(sheet & '$')])

[pradosh_thakur]

Try Below
FOR Each sheet in 'Sheet 1$', 'Sheet 2$'

[Test]:
LOAD F1 as ValueType,
F2 as Brand
FROM
[Excel.xls]
(biff, embedded labels, header is 4 lines, table is [$(sheet)] )
NEXT

[maxsugak]

The second one works, thank you!