Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Honored Contributor III

Re: LOAD sam type of data from multiple xls files

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!

Re: LOAD sam type of data from multiple xls files

// 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



pandunallani
Contributor II

Re: LOAD sam type of data from multiple xls files

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

Re: LOAD sam type of data from multiple xls files

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
Honored Contributor III

Re: LOAD sam type of data from multiple xls files

oknotsen
Honored Contributor III

Re: LOAD sam type of data from multiple xls files

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!
Community Browser