Reading from multiple excel in qlikview - same file multiple dumps

[Anonymous]

I have a requirement where the same set of fields in an excel file containing data shall be placed in a folder on monthly basis. I have to read from these on a monthly basis and the qlikview file has to get updated with the updated new excel that has been placed.

Please share the syntax with me for the load script to read from multiple excel files. As mentioned these excel files will have the same set of column names but the file name could be different and the data could be different. Also suggest something on the sheet name. Each excel will have only one sheet of data.

Load script syntax required for the above.

[mdmukramali]

Hi ,

If all the excel files are in the same Folder then

Load

[Field 1] ,

[Field 2] ,

and Etc

FROM

(ooxml, embedded labels, table is Sales);