LOAD sam type of data from multiple xls files

[#1]

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?

[oknotsen]

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

[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]

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.

[#5]

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

[oknotsen]

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.