Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Adding Multiple Excel Files to Qlikview

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 Replies
Not applicable

Re: Adding Multiple Excel Files to Qlikview

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

Not applicable

Re: Adding Multiple Excel Files to Qlikview

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

Community Browser