topic Re: Adding Multiple Excel Files to Qlikview in QlikView

Adding Multiple Excel Files to Qlikview

Mon, 24 Jun 2013 15:04:36 GMT

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

Re: Adding Multiple Excel Files to Qlikview

Mon, 24 Jun 2013 15:39:02 GMT

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

Re: Adding Multiple Excel Files to Qlikview

Tue, 25 Jun 2013 15:06:22 GMT

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