topic Daily Excel Data in QlikView

Daily Excel Data

ch_riadh — Tue, 22 Nov 2016 07:50:14 GMT

Hi,

I have an app, i'm loading daily data from excel sheet, the user add a new excel sheet every day,
For example : in day 3 i want to be able to see the data related to the three days in my app.

How i can load all the excels ?

Thanks

Re: Daily Excel Data

adamdavi3s — Tue, 22 Nov 2016 07:52:44 GMT

this might help

Loading from multiple Excel files and multiple sheets

There are so many threads on this subject that I am sure if you search you will find the answer 😉

Re: Daily Excel Data

Anonymous — Tue, 22 Nov 2016 07:56:05 GMT

You can load all at once using wildcard "*" if they are in the exact same format the will auto concatenate into one table:

Assume your files are called

mydata_20161121.xlsx

mydata_20161122.xlsx

mydata_20161123.xlsx

YourTable:

Load *

From mydata_*.xlsx

...;

Use the wildcard to substitute the variable part of the filename.

Re: Daily Excel Data

Tue, 22 Nov 2016 08:21:37 GMT

This is working...!