Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LOAD sam type of data from multiple xls files

Hi

i have load statement as follows:

LOAD

 

     A.LEVTIDPKT as PlanDelTime,

     A.ARTNRCH as EngVer,

     PROPVER

FROM

JA_2012.xlsx

(ooxml, embedded labels, table is ja_sim);

i have in the same folder files with same nameing on sheets

JA_2013.xlsx

JA_2014.xlsx

JA_2015.xlsx

how to make the load statmemnet work to read all data from the files?

6 Replies
oknotsen
Master III
Master III

Change the code to this:

LOAD

     A.LEVTIDPKT as PlanDelTime,

     A.ARTNRCH as EngVer,

     PROPVER

FROM

JA_201*.xlsx

(ooxml, embedded labels, table is ja_sim);

So edit the file name and replace the common part by a wildcard (star).

May you live in interesting times!
avinashelite

// to load all the files in the folder

LOAD

     A.LEVTIDPKT as PlanDelTime,

     A.ARTNRCH as EngVer,

     PROPVER

FROM

*.xlsx

(ooxml, embedded labels, table is ja_sim);

// to load the file stating with JA_

JA_*.xlsx



Anonymous
Not applicable
Author

Try this way..

LOAD

     A.LEVTIDPKT as PlanDelTime,

     A.ARTNRCH as EngVer,

     PROPVER

FROM

JA_201*.xlsx // '*' like this

So edit the file name and replace the common part by a star  symbol.

Not applicable
Author

Hi

i tried this way of solve this, no error when running the script, but only the data included in the first file for year 2012, is visibly in the visualisation.

vikasmahajan

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

or

Load all Excel files and all sheets in a folder

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
oknotsen
Master III
Master III

Are you sure about the names of your files as I also tested this with similar files (as this is how I teach it to my students) and it works every week.

May you live in interesting times!