for loop

[#1]

hi all,

i have excel with three sheets named sheet1,sheet2,sheet3

i want load those three sheets into qlikview using for loop    and

2.i have different excel  files dat1,dat2,dat3 how can i load using for loop  plz  help me with example

thanks

[senpradip007 · Accepted solution]

Try like:

for i = 1 to 3

for j = 1 to 3

  Tab:

  LOAD 'Dat'&$(i)&'-'&'Sheet'&$(j) as Source,

  F1,

      F2

  FROM

  (ooxml, embedded labels, table is Sheet$(j));

next

next

[qlikviewwizard]

Hi please check this thread.

Load Multiple excel sheets using For loop

[qlikviewwizard]

Try these links

Loading Multiple Excel sheets

Load all Excel files and all sheets in a folder