Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
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
vijetas42
Specialist
Specialist

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

Stars
Creator
Creator

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