Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ch_riadh
Contributor

Daily Excel Data

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

1 Solution

Accepted Solutions
qlikdeez
Valued Contributor

Re: Daily Excel Data

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.

3 Replies
adamdavi3s
Honored Contributor

Re: Daily Excel Data

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

qlikdeez
Valued Contributor

Re: Daily Excel Data

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.

Not applicable

Re: Daily Excel Data

This is working...!

Community Browser