Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

loading multiple xcel files from multiple folders

Hi all , i have 3 folders jandata,febdata,march data

in each folder i have -6 excel sheets loaded . i want all the folders data to keep in one qvd(extarctor).

i am giving some sample data. can anyone please help , how to load

under january folder i have excels like this

for week2 i have excel like this

for week1 i have  excel like this 

under febraury folder i have data like this

for week5.2 i have excel name like this

Can anyone please tell how to load all excel files under diffrent folders in same sinlgle qvd

3 Replies
Highlighted
Specialist
Specialist

Re: loading multiple xcel files from multiple folders

Please refer this thread it may help you.https://community.qlikview.com/thread/247144

or when you are trying to load excel one by one from same folder and your files having same sarting name then, e.g. you can directly write in from like,(excel folder path)..\Week*.xlsx

Highlighted
MVP
MVP

Re: loading multiple xcel files from multiple folders

Highlighted
Contributor III
Contributor III

Re: loading multiple xcel files from multiple folders

Did you figure this out?  I can't.  I want to do exactly what you're describing.