Adding Multiple Excel Files to Qlikview - Qlik Community

Report Inappropriate Content · ‎2013-06-24

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

Report Inappropriate Content · ‎2013-06-24

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

Report Inappropriate Content · ‎2013-06-25

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));