Adding Multiple Excel Files to Qlikview

[#1]

I am attempting to add multiple Excel files to Qlikview. I am getting error messages when using the script editor and attempting to upload a file using the Table Files Tab. The error I am receiving is attached as an image file to this post. Is there a possible solution to this issue? Or is there another way to upload multiple Excel files?

Thanks,

Shiv Kaushal

[#2]

It seems you missed a semicolon before the second LOAD. At the end of the previous line.

[#3]

Hi,

    I am Using this script with error handling.

See Example:

SET ErrorMode=0;

FOR Each excel_file in 'emp','interval','test1','test2','vijay'

FOR Each sheet in 'emp','Orderlog','Eventlog','sheet1','sheet2','table1','table2'

  $(sheet):

     LOAD  *

     From

     C:\Users\Vijay\Desktop\excel\$(excel_file).xlsx

     (ooxml, embedded labels, table is $(sheet));

NEXT

NEXT