Reading from multiple excel in qlikview - same file multiple dumps

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Reading from multiple excel in qlikview - same file multiple dumps

mdmukramali — Sun, 19 Nov 2017 10:16:51 GMT

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

topic Re: Reading from multiple excel in qlikview - same file multiple dumps in QlikView

Reading from multiple excel in qlikview - same file multiple dumps

Re: Reading from multiple excel in qlikview - same file multiple dumps